SS 2012 BOL Goes to CASE for IIF

Question

I used the Online population method for BOL.

INDEX lists IIF, but goes to CASE.

---

Kalman Toth SQL SERVER 2012 & BI TRAINING

Answer 1

Hi Kalman,

Thanks for pointing that out.  It's an oversight on our part.  We have an example in the CASE topic that shows how to use CASE to simulate IIF, which is relevant for the previous versions of SQL Server, but is no longer needed in SQL Server 2012 because of the addition of the IIF function.   I've updated the index keywords for the CASE topic.  The online version should point to the correct IIF topic in early September 2012.

Regards,

Gail

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

Thanks Gail.

---

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012