CHOOSE function in SQL Server 2012

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 215
CHOOSE() fucntion returns the value at the specified index position from the list. It is intriduced in SQL Server 2012.

syntax
CHOOSE ( index, Val1, Val2[, ...., Valn ])

It allows up to the maximum of 254 list of values(i.e. 254 arguments for listing values ) and 1 argument for specifying index position

Sample

DECLARE @Index INT = 2 -- 1= dev; 2 = Test; 3= QA; 4= Prod
,@DevPath VARCHAR(1000) = 'http://www.dev_geniiius.com'
,@TestPath VARCHAR(1000) = 'http://www.Test_geniiius.com'
,@QAPath VARCHAR(1000) = 'http://www.QA_geniiius.com'
,@PRODPath VARCHAR(1000) = 'http://www.PROD_geniiius.com'
SELECT CHOOSE( 2, @DevPath, @TestPath, @QAPath, @PRODPath ) as TheRealDeal


Output:
TheRealDeal 
http://www.Test_geniiius.com

Comments or Responses

Login to post response