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
If the job running very slow what is the action you do
What is spatial and temporal data?
How to insert data with null values?
Explain rdbms?
How to insert data into an existing table?
How to change parameter value inside the report?
How can I tell if sql server is 32 or 64 bit?
How can we delete Duplicate row in table?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How to defragment indexes with alter index ... Reorganize?
Write a SQL query to make a column as unique?
What is the difference between Triggers and Stored Procedure?
What is partition index in sql server?
What is a subquery in a select query statement in ms sql server?
Explain different types of locks in sql server.