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