Microsoft SQL Server 2012 introduces 14 new built-in functions. 2 Out 14 explained below.
Logical functions
· CHOOSE : CHOOSE acts like an index into an array, where the array is composed of the arguments that follow the index argument. The index argument determines which of the following values will be returned.
CHOOSE ( index, val_1, val_2 [, val_n ] )
· IIF : It returns one of the two values depending upon whether the Boolean expression evaluates to either True or False.
IIF ( boolean_expression, true_value, false_value )
Wonderful beat ! I wish to apprentice whilst you amend your site, how can i subscribe for a weblog web site? The account aided me a acceptable deal. I have been tiny bit familiar of this your broadcast provided brilliant clear idea
We’re a group of volunteers and opening a brand new scheme in our community. Your website offered us with useful info to paintings on. You’ve done an impressive job and our entire group can be grateful to you.