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 recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How do I find the port number for sql server?
Define Unique Key?
What is 2nf in normalization?
how can you attach more than 20 ldf files in sql server
What is store procedure? When do you use?
What are the types of subquery?
What is a Join and explain its types?
Write a query to find 5th highest amount paid from the customer table.
What is database isolation in sql server? : sql server database administration
What are SSL and TSL protocols?
How retrieve field names from the table in SQL through JAVA code?
what are the types of indexes? : Sql server database administration
How to create user messages with print statements in ms sql server?
How you can find out if an index is useful to the optimizer?