I recently came to know about the availability of IIF
function in SQL Server 2012. I always use nested CASE
in my queries. I want to know the exact purpose of the IIF
statement and when should we prefer using IIF
over CASE
Statement in the query.
I mostly use nested CASE
in my queries.
Thanks for all the inputs.
This question is related to
sql-server
sql-server-2012
case
iif
IIF is a non-standard T-SQL function. It was added to SQL SERVER 2012, so that Access could migrate to SQL Server without refactoring the IIF's to CASE before hand. Once the Access db is fully migrated into SQL Server, you can refactor.
Source: Stackoverflow.com