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 are the different types of collation sensitivity in sql server?
How to create dbo table in sql server?
Explain go command in sql server?
What is a transaction and why is it important?
How to loop through the result set with @@fetch_status?
How does Report Builder support Analysis Services cubes?
What are the types of containers in ssis?
How to count rows with the count(*) function in ms sql server?
How do you clear a log file?
what are the reporting service components in SSRS?
What is the difference between osql and query analyzer?
Can I disable or restrict ssrs export formats (rendering formats)?
what is the different types of backups available in sql server? : Sql server database administration
How to create a user to access a database in ms sql server using "create user" statements?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?