T-SQL Analyzer

# SQL Server Rule: SRD0063 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Design | | Class | AvoidIfInStoredProcRule | ## Rule Information | | | |----|----| | Id | SRD0063 | | Friendly Name | Avoid wrapping SQL in IF statement | | Category | Design | | Ignorable | true | | Applicable Types | Procedure | ## Description Do not use IF statements containing queries in stored procedures. ## Summary Avoid wrapping SQL statements in stored procedures with IF statements. Consider extracting the nested SQL statements to their own stored procedure. ### Examples ```sql CREATE PROCEDURE dbo.TestWithExists AS Set nocount on IF EXISTS(SELECT * FROM dbo.TestTableSSDT) BEGIN SELECT Idcol from dbo.TestTableSSDT end -- SML005, SRD0063 ``` _{^{Generated by a tool}}