Using IIF in query for Linked Tables SQL Server 2012
In SQL Server 2012, the T-SQL languaged added the IIF. The IIF is actually a wrapper that converts to a T-SQL Case statement during runtime.
My SQL Server is 2008R2. The IIF is not part of the T-SQL language.
My MS Access 2010 uses a DSN-Less connection using SQL Server Native Client 11.0 (the latest one for SQL Server 2013).
Does the ODBC (Native Client) translate the IIF in an Access Query into a Case statement for the SQL Server side?
For speed purposes, I am trying to determine if to invest the overhead in re-writing Stored Procedures with Case statements - or if the ODBC is doing the job for me anyway?
Were you lucky enough to get an answer? Please mark your question as [SOLVED] The original poster can go to Thread Tools to mark it as Solved.
Quotation Thomas Jefferson: "Peace is that brief glorious moment in history when everybody stands around reloading."
There are 2 Kinds of Countries on this Planet
1. Those that use the Metric System
2. Those that had a man walk on the moon
Denver, Colorado - The "Mile High City" - non-metric!