SQL SERVER – SET QUOTED_IDENTIFIER – SET Statement @SQLSERVER
SET QUOTED_IDENTIFIER : It allows ISO standard for using quotation marked SQL Server reserved keywords as identifier and literal strings.
So, using this setting we can create an identifier or objrct name with any SQL Server keywords. Normally, we cannot use any keywords as an identifier in the statements.
SET QUOTED_IDENTIFIER ON
SET QUOTED_IDENTIFIER OFF
When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literal must be delimited by single quotation marks.
When SET QUOTED_IDENTIFIER is OFF, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers.
1. QUOTED_IDENTIFIER is OFF and when we execute the follow SQL query, SQL Server will throw an error message.
create table “table”