What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?

Question

Anonymous User · Answer

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.

interview

What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?

Can you answer this question?

1 Answers