Home

Rule description

• Jump statements should not be followed by dead code

Non-compliant Code Example

CREATE PROCEDURE checkstate @param varchar(11)  
AS  
BEGIN
IF (SELECT StateProvince FROM [Data].AdditionalContactInfo WHERE ContactID = @param) = 'WA'  
BEGIN
	Select [state]
	From StateRecord
	Where name = @param;
END

RETURN;
Print 'Checkstate procedure ends';  --Non compliant code (Print statement won't get execute, it is a dead code)
END;
GO

Compliant Code Example

CREATE PROCEDURE checkstate @param varchar(11)  
AS  
BEGIN
IF (SELECT StateProvince FROM [Data].AdditionalContactInfo WHERE ContactID = @param) = 'WA'  
BEGIN
	Select [state]
	From StateRecord
	Where name = @param;
END

Print 'Checkstate procedure ends';   --Compliant code
RETURN;
END;
GO