What does it mean to have quoted_identifier on? What are the
implications of having it off?
Answer Posted / 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 |
Post New Answer View All Answers
What is the importance of a recovery model?
What is optimistic concurrency?
How to backup SQL Server Reporting Services ?
What are the properties of the transaction?
Explain the steps needed to create a scheduled job?
How to return the top 5 rows from a select query in ms sql server?
Explain primary key, foreign key and unique key?
What are the underflow and overflow behaviors on float literals?
What is table valued function and scalar valued functions?
What is identity?
How to get all stored procedures in sql server?
How many clustered indexes there can be on table ?
Does an index slow down updates on indexed columns?
Which are the important points to note when multilanguage data is stored in a table?
What is the command used to check locks in microsoft sql server?