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
Difference between connected and disconnected database in .net with sql server?
What is data source document?
What is the fastest way to permanently delete a 1 million row table named customers?
How do you delete duplicate records in sql server?
What is table level trigger?
What is the use of group by clause?
what are the critical issues you have resloved in your company
How to create an multi-statement table-valued function?
Is null vs coalesce?
How ssrs maintain security?
You want to implement the one-to-many relationship while designing tables. How would you do it?
What are the approximate numeric data types?
What are the differences between having and where clause.
Write a SQL query to delete a table?
what is a mixed extent? : Sql server administration