T-SQL Analyzer

# SQL Server Rule: SRP0021 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Design | | Class | AvoidParameterModificationRule | ## Rule Information | | | |----|----| | Id | SRP0021 | | Friendly Name | Manipulated parameter value | | Category | Performance | | Ignorable | true | | Applicable Types | Procedure | ## Description Avoid modification of parameters in a stored procedure prior to use in a select query. ## Summary Avoid modification of parameters in a stored procedure prior to use in a select query. ### Remarks For best query performance, in some situations you'll need to avoid assigning a new value to a parameter of a stored procedure within the procedure body, and then using the parameter value in a query. The stored procedure and all queries in it are initially compiled with the parameter value first passed in as a parameter to the query. _{^{Generated by a tool}}