In this article, we will discuss the difference between SET QUOTED_IDENTIFIERS ON and SET QUOTED_IDENTIFIERS OFF. Please go through the article SET QUOTED_IDENTIFIER ON/OFF Setting in SQL Server to have detailed information on this setting. It is better practice to use SET QUOTED_IDENTIFIERS ON setting.
SET QUOTED_IDENTIFIERS ON
SET QUOTED_IDENTIFIERS OFF
Table
SET QUOTED_IDENTIFIER ON GO CREATE TABLE dbo.”Table” (id int,”Function” VARCHAR(20)) GO
SET QUOTED_IDENTIFIER OFF _ GO CREATE TABLE dbo.”Table” (id int,”Function” _ VARCHAR(20)) GO
SET QUOTED_IDENTIFIER ON GO SELECT “BIRADAR”
SET QUOTED_IDENTIFIER OFF GO SELECT “BIRADAR”
SET QUOTED_IDENTIFIER ON GO SELECT ‘BIRADAR’
SET QUTOED_IDENTIFIERS ON/OFF
SET QUTOED_IDENTIFIERS setting as ON:SELECT OBJECT_NAME _ (object_id) _ FROM sys.sql_modules _ WHERE uses_quoted_identifier = 1
with SET QUTOED_IDENTIFIERS_ setting as OFF:_ SELECT OBJECT_NAME _ (object_id) _ FROM sys.sql_modules _ WHERE _ uses_quoted_identifier = 0
Please correct me if my understanding is wrong. Comments are always welcome.
