Tag Archives: Msg 125 Level 15 State 2 Line 6 Case expressions may only be nested to level 10

How to use IIF() in SQL Server ?

SQL Server Denali CTP3 has introduces a new function IIF() to evaluates specified expression and returns specified true/false values. IIF(), is kind of shorthand way of writing a CASE expression where we can expect only two result either true or false. This function is same as available in other languages. IIF(), accepts three parameters, First [...]