Skip to content

SRD0063.md

Latest commit

 

History

History
29 lines (19 loc) · 720 Bytes

SRD0063.md

File metadata and controls

29 lines (19 loc) · 720 Bytes

SQL Server Rule: SRD0063
Assembly SqlServer.Rules.dll
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.