Home > DeveloperSection > Interviews > What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?

Posted on    May-11-2011 5:13 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  1329  View(s)
Rate this:

Awadhendra Tiwari

Total Post:510

Posted on    May-11-2011 12:00 AM

When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks. When SET QUOTED_IDENTIFIER is OFF, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers.

Don't want to miss updates? Please click the below button!

Follow MindStick