Home

Rule description

• Multiline blocks should be enclosed in BEGIN...END blocks

Non-compliant Code Example

IF (@Number > 10) -- Non compliant code (Multi-line blocks are not enclosed in the BEGIN ... END blocks.)
	BEGIN
	    EXEC GetEmployee;
	    EXEC GetCustomer;  
	END  
Else IF (@Number < 10) 
	EXEC GetEmployee;

Compliant Code Example

IF (@Number > 10) -- Compliant code (Multi-line blocks are enclosed in the BEGIN ... END blocks.)
BEGIN
  EXEC GetEmployee;
  EXEC GetCustomer;  
END
Else IF (@Number < 10) 
	EXEC GetEmployee;