If you are talking about...

If you are looking to audit CURD operations on tables. Like if you want to know which columns have been updated and want to know the old values as well,...

Thanks Ron for another one on SS 2012.

Though I understood the CHOOSE function well, but have to query Employee table to get the answer correctly.

Nice question. Thanks!

Got this question wrong!

But yes there is a scope for improvement. Either question could have provided more details or answer choices could have been framed better (as pointed out...

Good one. Thanks!

An easy one for the day. Looking at all the answers, it was quite obvious to find the correct one (the odd one out).

Posting the correct link:

http://msdn.microsoft.com/en-us/library/ms177603.aspx

Thanks!

Thanks Ron for another one on SS 2012!

I knew there was a discussion on similar question recently, still got the answer wrong 🙂

Whilst, I was trying to look at the queries executed in estimated execution plan, my...

I did observed this strange behavior, but was not aware of the reason behind this. Thanks 🙂

Easy one for the day. Thanks 🙂

humm... Try this out then

Execute this first:

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1

GO

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1

GO

Then try to execute your query with this change:

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

'Excel 8.0;Database=C:\Users\sathiyanr\Desktop\dynamic.xlsx',

'SELECT * FROM [Sheet1$]')

Try to execute the following set of commands and check if this works:

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Ad Hoc Distributed Queries', 1;

GO

RECONFIGURE;

GO

Thanks Wayne. Got to learn something new today 🙂

Wow.. Thanks Ron for another one on SS2012 🙂