Home / Software / Tips and Tricks / What is the significance of "QUOTED_IDENTIFIER ON/OFF "in a SQL Server Stored Procedure?

What is the significance of "QUOTED_IDENTIFIER ON/OFF "in a SQL Server Stored Procedure?

Updated:  07/29/2016 07:07 AM
Author:  Shiju Mathews

Status:    Resolved.


It specifies how SQL Server treats the data that is defined in Single Quotes and Double Quotes. When it is set to ON any character set that is defined in the double quotes “” is treated as a T-SQL Identifier (Table Name, Proc Name, Column Name….etc) and the T-SQL rules for naming identifiers will not be applicable to it. And any character set that is defined in the Single Quotes ‘’ is treated as a literal.



References : https://msdn.microsoft.com/en-us/library/ms174393.aspx