Case « Select Query « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Select Query
  3. Case
1.Select case statement
2.Case when and else
3.CASE: return a specified value based on a set of business logic
4.Use CASE in the UPDATE statement
5.'Case when' statement in a procedure
6.Case When with else
7.Case when NULL
8.Case when with Mod and ABS()
9.A simple CASE takes an expression that equates to a Boolean result