dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Working with the IIF Statement in T-SQL

See how to quickly check for certain conditions with an IIF statement in T-SQL.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


You can use the IIF statement to check quickly for conditions. For example:

DECLARE @Spy varchar(20) = '07'
 
SELECT IIF(@Spy = '007', 'Bond, James Bond', 'Ernst Stavro Blofeld')

If the Spy Variable is 007, then it will return "Bond, James Bond." If it is anything else, it will return the second part of the statement, which is: "Ernst Stavro Blofeld"

 

Visit the DevX Tip Bank

 





   
Thanks for your registration, follow us on our social networks to keep up-to-date