Home
CASE expressions should end with ELSE clauses
Rule description
- CASE expressions should end with ELSE clauses
Non-compliant Code Example
SELECT OrderID, Quantity, CASE WHEN Quantity > 30 THEN 'The quantity is greater than 30' WHEN Quantity = 30 THEN 'The quantity is 30' END AS QuantityText --Non compliant code FROM OrderDetails;
Compliant Code Example
SELECT OrderID, Quantity, CASE WHEN Quantity > 30 THEN 'The quantity is greater than 30' WHEN Quantity = 30 THEN 'The quantity is 30' ELSE 'The quantity is under 30' --Compliant code END AS QuantityText FROM OrderDetails;