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 to use "if ... Else if ... Else ..." Statement structures in ms sql server?
How to display a past time in days, hours and minutes?
What is the default server name for sql server?
Do you know what are pages and extents? : SQL Server Architecture
What is extent? Types of extents?
How to download and install the scaled-down database adventureworkslt?
Explain what is row_number function?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What are cascading parameters in ssrs reports?
How to list all user defined functions in the current database?
‘Order by’ is not allowed in a view how can you sort information from a view?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What is compound operators?
What happens if null values are involved in string operations?