Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Sep 6, 2000

IIF Function Under SQL Server 7.0

Question:
Is the IIF function valid under SQL server 7.0? It's in the SQL Books Online as valid, but none of my stored procedures accept it.

Answer:
The IIF function you refer to in Books Online isn't part of the T-SQL syntax that your stored procedures expect. Instead it is used when writing code for Microsoft's OLAP services. In T-SQL you will have to expand the statement to if.. then.. else..

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

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