Home
Conditionally executed code should be denoted by either indentation or BEGIN...END block
Rule description
- Conditionally executed code should be denoted by either indentation or BEGIN...END block
Non-compliant Code Example
DECLARE @Number int;
SET @Number = 50;
IF @Number > 100 --Non compliant code (IF and ELSE IF statements are not denoted by either indentation or BEGIN...END block)
PRINT 'The number is large.';
ELSE IF @Number < 10
PRINT 'The number is small.';
ELSE
PRINT 'The number is medium.';
GO
Compliant Code Example
DECLARE @Number int;
SET @Number = 50;
IF @Number > 100 --Compliant code (IF and ELSE IF statements are denoted by either indentation or BEGIN...END block)
PRINT 'The number is large.';
ELSE
BEGIN
IF @Number < 10
PRINT 'The number is small.';
ELSE
PRINT 'The number is medium.';
END ;
GO