case in mssql code example

Example 1: sql CASE

/*CASE statements are used to create different outputs and is 
  used by SQL as a way to handle if-then logic.*/
  
  SELECT column_name,
    CASE 
      WHEN condition THEN 'Result_1'
      WHEN condition THEN 'Result_2'
      ELSE 'Result_3'
    END
  FROM table_name;

Example 2: tsql case when

-- Syntax for SQL Server, Azure SQL Database and Azure Synapse Analytics
  
--Simple CASE expression:   
CASE input_expression   
     WHEN when_expression THEN result_expression [ ...n ]   
     [ ELSE else_result_expression ]   
END   

--Searched CASE expression:  
CASE  
     WHEN Boolean_expression THEN result_expression [ ...n ]   
     [ ELSE else_result_expression ]   
END