What does it mean to have quoted_identifier on? What are the
implications of having it off?
Answer Posted / bobby
When SET QUOTED_IDENTIFIER is ON, identifiers can be
delimited by double quotation marks, and literals must be
delimited by single quotation marks. When SET
QUOTED_IDENTIFIER is OFF, identifiers cannot be quoted and
must follow all Transact-SQL rules for identifiers. For more
information, see Identifiers. Literals can be delimited by
either single or double quotation marks.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Write a sql query to delete duplicate records from a table called table1
What is xdr?
What is sql server used for?
Do you think BCNF is better than 2NF & 3NF? Why?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What do you understand by mirroring?
What is the purpose of indexing?
what are the Prerequisites for Replication?
What are data resources?
Explain different backup plans?
Explain various On-Delete options in a DB table. Which is the default option?
What happens when the SQL Azure database reaches Max Size?
How can you set the threshold at which sql server will generate keysets asynchronously?
What is a dataset and what are the different types of datasets?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.