Difference Between QUOTED_IDENTIFIER ON and QUOTED_IDENTIFIER OFF In SQL Server

In this blog we learn about the Difference b/w QUOTED_IDENTIFIER ON and QUOTED_IDENTIFIER OFF command.

When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks. It other words when QUOTED_IDENTIFIER is set to ON then string inside treated as a identifier not as a literal.

 

Example

 

 

 

 

When SET QUOTED_IDENTIFIER is Off literals can be delimited by double quotation marks. It other words when QUOTED_IDENTIFIER is set to ON then string inside treated as a literal not as a literal.

 

Example