Rx_
Nothing In Moderation
- Local time
- Yesterday, 21:20
- Joined
- Oct 22, 2009
- Messages
- 2,803
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?
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?