dineshbabus (12/3/2012)
By Default "Quoted Identifier" Will be ON. Eventhoug if we didn't set any options. the syntax will work fine. Please correct me if i'm wrong.
The default is OFF (see http://msdn.microsoft.com/en-us/library/ms190707(v=sql.105).aspx and http://msdn.microsoft.com/en-us/library/ms191203(v=sql.105).aspx).
However, most client applications SET QUOTED_IDENTIIFIER ON when they connect.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi