Home

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