For more information, see CASE (Transact-SQL). The fact that IIF is translated into CASE also has an impact on other aspects of the behavior of this function. Since CASE expressions can be nested only ...

IIF Function: Similar to the IF function, but specific to SQL Server. It evaluates both the true and false values before returning one of them, which means both values must be compatible and valid.

IIF is a shorthand way for writing a CASE expression. It evaluates the Boolean expression passed as the first argument, and then returns either of the other two arguments based on the result of the ...

Logical Functions The next grouping of new T-SQL commands is logical functions; they include two new commands, CHOOSE and IIF. These commands are used for logical operations to help control the ...