What do we mean by QUOTED_IDENTIFIER in Sql Server?

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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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:-