70-461 Training Kit Chapter 2, Lesson 2: Functions & Expression
CASE Expression: Is an expression Return values 2 types: simple and search Expression Functions: COALESCE (standard) NULLIF (standard) Syntax: NULLIF( expression, expression) Return a NULL mark if two expressions are equal. ISNULL (TSQL specific) Logical Functions (available in SQL Server 2012) CHOOSE Syntax: CHOOSE( index, val_1, val_2, [, val_n]) Return a value at specified index Index is based 1 IIF Syntax: IIF( boolean_expression, true_value, false_value) Date and Time Functions: GETDATE (TSQL specific) CURRENT_TIMESTAMP (standard) ...