What does it mean to have quoted_identifier on? What are the implications of having it off?

Post

View All

Raj Kumar M

What does it mean to have quoted_identifier on? What are the implications of having it off?

By Raj Kumar M in SQL Server on Jan 29 2010

0
6.5k
1

Post Your Answer

Jan, 2010 29
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.
- 0