Home
SQL Server / T-SQL Tutorial
Query
Insert Delete Update
Table
Table Join
Data Types
Set Operations
Constraints
Subquery
Aggregate Functions
Date Functions
Math Functions
String Functions
Data Convert Functions
Analytical Functions
Sequence Indentity
View
Index
Cursor
Database
Transact SQL
Procedure Function
Trigger
Transaction
XML
System Functions
System Settings
System Tables Views
User Role
CLR
Case « Query « SQL Server / T-SQL Tutorial
SQL Server / T-SQL Tutorial
Query
Case
1.23.Case
1.23.1.
The syntax pattern for case
1.23.2.
The syntax of the searched CASE function
1.23.3.
A Simple CASE
1.23.4.
CASE Expression
1.23.5.
Automatic Code Generation for CASE Expressions
1.23.6.
Summarizing Data Using the CASE Expression
1.23.7.
Using a CASE expression to sum sales by weekday.
1.23.8.
Using the CASE Expression with Complex Conditions
1.23.9.
Summarizing Data Using the Searched CASE Expression
1.23.10.
A SELECT statement that uses a simple CASE function
1.23.11.
A SELECT statement that uses a searchable CASE function
1.23.12.
Searched CASE expression looks for the first expression that evaluates to true.
1.23.13.
Update statement based on case condition
1.23.14.
Case when else
1.23.15.
Alias for case statement
1.23.16.
Use two case statements in one select statement
1.23.17.
Case then with query
1.23.18.
Case with range
1.23.19.
Doing a calculation in a Searched CASE