Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: July 2011

Denali–IIF and CHOOSE

In Denali CTP3, we have a new of new functions to play with.  For this post, im going to focus on IIF and CHOOSE.

The syntax of these are :

IIF(<condition>,<true expresssion>,<false expression>)

and

CHOOSE(<value>,<when 1 expression>,<when 2 expression>………)

On the face of it these are simple replacements for… Read more

4 comments, 380 reads

Posted in Dave Ballantynes blog on 19 July 2011