皆さんは、IF、IIF、CASEといった論理関数の使い方や特徴をしっかり理解していますか？私は、KTさんの動画でIIFが登場したとき、「なんだこの関数は？」と疑問に思ったのを覚えています。 今回は、この3つの論理関数について整理しながら、記事で分かり ...

Previously, when the condition (1st argument) of the IIF function could be evaluated (folded) to false, the `IfConditional` was eliminated which caused `IndexOutOfBoundsException` to be thrown when ...

The IIF statement introduced recently in the code errors SQL Server 2008 and 2008R2 due to the IIF statement being introduced in SQL Server 2012. Now I know a lot of us including myself would only ...