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?

Anonymous User

Can you answer this question?

1 Answers

Liked By