Home
Multiline blocks should be enclosed in BEGIN...END blocks
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;