SQL Clone
SQLServerCentral is supported by Redgate
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>)


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

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

4 comments, 783 reads

Posted in Dave Ballantynes blog on 19 July 2011