Home

Rule description

• Jump statements should not be redundant

Non-compliant Code Example

WHILE ( SELECT AVG(ListPrice) FROM dbo.DimProduct) < $300  
BEGIN  
    UPDATE dbo.DimProduct  
        SET ListPrice = ListPrice * 2;  
    Continue;    --Non compliant code (Redundant jump statement in while loop)
    SELECT MAX ( ListPrice) FROM dbo.DimProduct  
END 

Compliant Code Example

WHILE ( SELECT AVG(ListPrice) FROM dbo.DimProduct) < $300  
BEGIN  
    UPDATE dbo.DimProduct  
        SET ListPrice = ListPrice * 2;  
    SELECT MAX ( ListPrice) FROM dbo.DimProduct  
    IF ( SELECT MAX (ListPrice) FROM dbo.DimProduct) > $500  --Compliant code (Loop break only when particular condition achieved.)
        BREAK;  
END