What does it mean to have quoted_identifier on? What are the
implications of having it off?
Answer Posted / bobby
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. For more
information, see Identifiers. Literals can be delimited by
either single or double quotation marks.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How data can be copied from one table to another table?
What are scalar functions in sql?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What are the acid properties?
How to count groups returned with the group by clause in ms sql server?
Define Wed Edition in SQL Azure?
What is catalog views?
Explain forward - only cursors?
What is tempdb in sql server?
How to add the custom code in Report?
What are temporal tables in sql server 2016?
What is surrogate key? : sql server analysis services, ssas
how to take backup bcp out for a column in table in sql server?
Why use update_statistics command in sql server?
Explain the types of indexes.