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 bcnf normalization form?
What are functions in the sql server?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
how to take backup bcp out for a column in table in sql server?
How to use values from other tables in update statements in ms sql server?
How to use the inserted and deleted pseudo tables?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is the use of for clause?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
How to convert character strings into numeric values?
What is a filestream?
how you can list all the tables in a database?
What is the report builder?
What are points to remember while using the fillfactor argument?
How to select all columns of all rows from a table with a select statement in ms sql server?