How to use Switch in SQL Server

In SQL Server, there isn't a built-in SWITCH function like you might find in some programming languages. However, you can achieve the same behavior using the CASE statement. The CASE expression allows you to evaluate multiple conditions and return a result when the first condition is met, functioning similarly to a SWITCH or IF-ELSE block.

Here's how it works:

Syntax:

SELECT 
  CASE 
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    ...
    ELSE default_result
  END AS alias_name
FROM table_name;

Example:

Suppose you have an Orders table with a StatusCode column, and you want to return a readable status:

SELECT 
  OrderID,
  CASE 
    WHEN StatusCode = 1 THEN 'Pending'
    WHEN StatusCode = 2 THEN 'Shipped'
    WHEN StatusCode = 3 THEN 'Delivered'
    ELSE 'Unknown Status'
  END AS OrderStatus
FROM Orders;

Key Points:

• The CASE expression is flexible and can be used in SELECT, WHERE, ORDER BY, and HAVING clauses.
  
• It's readable and works well when you have a manageable number of conditions.
  
• Always include an ELSE clause to handle unexpected or null values.
  

In summary, while SQL Server doesn’t support a SWITCH keyword directly, the CASE expression is a powerful alternative that lets you write clean and efficient conditional logic within your SQL queries.