Home
Jump statements should not be redundant
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