SQL IIF Function

The IIF function is the new built-in Logical function introduced in SQL Server 2012. We can consider the SQL IIF as the shorthand way of writing IF Else and CASE statements. SQL Server IIF function will accept three arguments. The first argument is the Boolean expression, which returns true or false. If the IIF expression … Read more