T-SQL Analyzer

# SQL Server Rule: SRD0016 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Design | | Class | ConsiderRemovingUnusedParameterRule | ## Rule Information | | | |----|----| | Id | SRD0016 | | Friendly Name | Unused input parameter | | Category | Design | | Ignorable | true | | Applicable Types | Procedure | | | Scalar Function | | | Table Valued Function | ## Description Input parameter never used. Consider removing the parameter or using it. ## Summary Removed unreferenced parameters ### Examples ```sql CREATE PROCEDURE dbo.MultiCteTest @pInsertCount INT = 0 OUTPUT AS BEGIN set nocount on ; WITH successfulOrder AS ( SELECT * from dbo.TestTableSSDT ) INSERT INTO dbo.TestTableSSDT ( Col1 ) SELECT col1 from successfulOrder; END; -- SML005, SRD0016 ``` ### Remarks This rule checks for not used stored procedure or function input parameters. Unused parameters not necessarily negatively affect the performance, but they just add bloat to your stored procedures and functions. _{^{Generated by a tool}}