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
How to enforce security in sql server? : sql server security
What is #table in sql server?
What is the fillfactor concept in indexes?
How to delete existing rows in a table?
What are the new features of sql server 2008 r2 reporting service?
What does it mean if @@cursor_row returns a negative number?
Can sql server be linked with other servers like oracle?
How do I create a stored procedure in sql server?
Why use cursor in sql server?
What is @@error in sql?
What is tempdb database? : SQL Server Architecture
last function used in MS Access to convert sql what function will use in sql
What is left outer join in sql server joins?
What is self contained scalar sub query?
What is a virtual table in sql?