Collections:
CASE - Conditional Expressions in SQL Server
What Are Conditional Expressions in SQL Server Transact-SQL?
✍: FYIcenter.com
A conditional expression returns one of the given expressions based a specific condition. SQL Server 2005 offers the CASE operator to present a conditional expression with two syntaxes:
1. CASE with simple conditions CASE test_value WHEN value_1 THEN expression_1 WHEN value_2 THEN expression_2 ... WHEN value_n THEN expression_n ELSE expression_o END -- Returns "expression_x" if "test_value" equals to "value_x". 2. CASE with complex conditions CASE WHEN condition_1 THEN expression_1 WHEN condition_2 THEN expression_2 ... WHEN condition_n THEN expression_n ELSE expression_o END -- Returns "expression_x" if "condition_x" is TRUE.
Here are two examples on how to use the CASE operator:
DECLARE @command VARCHAR(10); SET @command = 'S'; SELECT CASE @command WHEN 'A' THEN 'Add' WHEN 'S' THEN 'Save' WHEN 'Q' THEN 'Quit' ELSE 'Unknown command.' END; GO Save DECLARE @command VARCHAR(10); SET @command = 'Q'; SELECT CASE WHEN @command = 'A' THEN 'Add' WHEN @command = 'S' THEN 'Save' WHEN @command = 'Q' THEN 'Quit' ELSE 'Unknown command.' END; GO Quit
⇒ What Are Comparison Operations in SQL Server
⇐ What Is a Boolean Value in SQL Server
⇑ Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-29, 1533🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...