SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: February 2014

THE IIF statement – SQL has it at last.

G’day All,

While I was writing my last blog post about the new SQL SERVER 2012 CHOOSE statement, it also came to my notice that we additionally have the IIF statement.

Again, this was added in 2012.

I’d assume that most people would be familiar with this… Read more

0 comments, 13,671 reads

Posted in measure twice, cut once. on 18 February 2014

The CHOOSE keyword


I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced in SQL SERVER 2012.
So what does it do?
Well basically a label can be applied at a specific index in a list.
Here’s a demonstration script… Read more

0 comments, 1,538 reads

Posted in measure twice, cut once. on 17 February 2014