What does it mean to have quoted_identifier on? What are the
implications of having it off?
Answers were Sorted based on User's Feedback
Answer / koti-khammam
when QUOTED_IDENTIFIER option is specified as ON ,the
identifiers are placed with in double quotation and
constants are placed with in single quotation.
when QUOTED_IDENTIFIER is OFF,the identifiers are not placed
with in double quotation and we must follow all T-SQL rules
for the identifiers.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.
Do you know the policy based administration feature of sql server 2008?
What is query and its types?
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?
How to write a query with a right outer join in ms sql server?
What is sub query and its properties?
What is query cost in sql server?
What is the difference between char, varchar and nvarchar?
What number aggregate functions are accessible there in sql?
Can we have more than one NULL in a column having unique constraint?
What is row_number function?
What are the steps to process a single select statement?