SQL 2012 IIF() Function and CASE Expression
By SQLRx Admin | SQL Server , Tip of the Month
A new function available in SQL Server 2012 is IIF. IIF is very similar to the CASE expression and is in essence a shorthand way to write a CASE function. The IIF function returns one of two values depending on whether the first expression evaluates to TRUE or FALSE. The IIF function can be nested […]
Continue reading