In simple words, the IIF() function returns "true_value" if a condition is TRUE, or "false_value" if a condition is FALSE. Key Points IIF is a logical function in SQL Server. IIF was introduced in SQL Server 2012. IIF is a shorthand way for writing a CASE Expression. IIFs can ...