What is set_quoted_identifier?

 Posted by Ddd on 2/2/2011 | Category: Sql Server Interview questions | Views: 2139 | Points: 40

It is a statement that allows us to use double quotes when namimg the objects

for example:
1)create table "demo"
(ono int)

2)create table "select"
(sno int)

These 2 statements will work only when
set quoted_identifier on

set quoted_identifier off

Both the statements will fail

set quoted_identifier is on by default

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response