T-SQL Analyzer

# SQL Server Rule: SRP0010 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Performance | | Class | AvoidFunctionsInActionQueries | ## Rule Information | | | |----|----| | Id | SRP0010 | | Friendly Name | Function in data modification | | Category | Performance | | Ignorable | true | | Applicable Types | Procedure | | | Scalar Function | | | Table Valued Function | ## Description Avoid the use of user defined functions with UPDATE/INSERT/DELETE statements. (Halloween Protection) ## Summary Avoid the use of functions with UPDATE / INSERT / DELETE statements. (Halloween Protection) ### Remarks When a user defined function that does not use <c>SCHEMABINDING</c> is used in an action query the data modifications have to be spooled to tempdb in a two step operation. _{^{Generated by a tool}}