RSS‎ > ‎

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

posted Sep 3, 2012, 5:06 AM by Ashish Jain
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.