Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
SQL database in Microsoft Fabric
Causes SQL Server to follow the ISO rules regarding quotation mark delimiting identifiers and literal strings. Identifiers delimited by double quotation marks can be either Transact-SQL reserved keywords or can contain characters not generally allowed by the Transact-SQL syntax rules for identifiers.
Transact-SQL syntax conventions
Syntax
Syntax for SQL Server, Azure SQL Database, serverless SQL pool in Azure Synapse Analytics, and Microsoft Fabric.
SET QUOTED_IDENTIFIER { ON | OFF }
Syntax for Azure Synapse Analytics and Parallel Data Warehouse.
SET QUOTED_IDENTIFIER ON
Remarks
When SET QUOTED_IDENTIFIER is ON (default), identifiers can be delimited by double quotation marks (""), and literals must be delimited by single quotation marks (''). All strings delimited by double quotation marks are interpreted as object identifiers. Quoted identifiers don't have to follow the Transact-SQL rules for identifiers. They can be keywords and can include characters that aren't allowed in Transact-SQL identifiers. If a double quotation mark (") is part of the identifier, it can be represented by two double quotation marks (""). SET QUOTED_IDENTIFIER must be ON when reserved keywords are used for object names in the database.
When SET QUOTED_IDENTIFIER is OFF, identifiers can't be quoted and must follow all Transact-SQL rules for identifiers. For more information, see