choose :- New function in sql server denali



CHOOSE

Retruns value at specified index from list of values

lets see it

SELECT Choose (1, ‘a’, ‘b’, ‘c’, ‘d’)


If no value presents at specified index than it returns null

SELECT Choose (7, ‘a’, ‘b’, ‘c’, ‘d’)

Leave a comment


Design a site like this with WordPress.com
Get started