What does it mean to have quoted_identifier on? What are the
implications of having it off?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What are the different authentication modes in sql server?
How you can change a cross join into an inner join?
when inserting to a table how many rows will be effected using triggers
Explain indexed views and partitioned view with their syntax.
what is replication? where do u use Go Keyword?
Selet all the data from table where last name is n of employee
What is meant by datasource?
What is data compression?
What is the purpose of a table?
What is a unique key constraint?
What are different types of data sources?
what is the importence of the trigger in sqlserver2000?