Achieving IIF Functionality in T-SQL

The syntax for the IIF command in T-SQL is:

select case when  then when  then ....else endfrom 

In the following example, the bit data type will store either 0 or 1. Using the IIF query, a result is provided in a meaningful way as follows:

select case availability     when 0 then 'Not Available'     else 'Available' end from table1

Where availability is the field name in table1, datatype bit.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: