What do we mean by QUOTED_IDENTIFIER in Sql Server?

 Posted by vishalneeraj-24503 on 12/15/2014 | Category: Sql Server Interview questions | Views: 762 | Points: 40
Answer:

QUOTED_IDENTIFIER differentiates between single and double quotation marks when evaluating an expression.It has 2 options ON/OFF.By-default it OFF and when it is OFF,then single quotation mark is used and when set to ON,then double quotation mark is used.
Syntax:-
QUOTED_IDENTIFIER ON/OFF


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response