Tutorial by Examples

SQL Server 2012 Returns the item at the specified index from a list of values. If index exceeds the bounds of values then NULL is returned. Parameters: index: integer, index to item in values. 1-based. values: any type, comma separated list SELECT CHOOSE (1, 'apples', 'pears', 'oranges', 'b...

SQL Server 2012 Returns one of two values, depending on whether a given Boolean expression evaluates to true or false. Parameters: boolean_expression evaluated to dtermine what value to return true_value returned if boolean_expression evaluates to true false_value returned if boolean_expressi...