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
CASE Statement in the query.
I mostly use nested
CASE in my queries.
Thanks for all the inputs.
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.