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
What is the osql utility?
Explain about system stored procedure?
Give an example of SQL injection attack ?
Explain microsoft sql server functions?
What is a synonym for manipulation?
What is system stored procedures?
What are sparse columns?
Which sql server table is used to hold the stored procedure script?
What is difference between oltp and olap?
Explain the stored procedure?
What is @@error in sql?
Differentiate between sql temp table vs table variable?
How to backup encryption key ?
Name some of the open source software that you can use in alternative to SSR?
What is the synonym of join?