Home
Collapsible if statements should be merged
Rule description
- Collapsible if statements should be merged
Non-compliant Code Example
DECLARE @Number int;
SET @Number = 50;
IF @Number > 100
IF @Number < 200 --Non compliant code (Two if condition we can be merged)
PRINT 'The number is large.';
ELSE
BEGIN
IF @Number < 10
PRINT 'The number is small.';
ELSE
PRINT 'The number is medium.';
END ;
GO
Compliant Code Example
DECLARE @Number int;
SET @Number = 50;
IF @Number > 100 AND @Number < 200 --Compliant code
PRINT 'The number is large.';
ELSE
BEGIN
IF @Number < 10
PRINT 'The number is small.';
ELSE
PRINT 'The number is medium.';
END ;
GO