SET QUOTED_IDENTIFIER#
Causes Querona 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.
Syntax#
SET QUOTED_IDENTIFIER { ON | OFF } [;]
Remarks#
Argument values are ignored and do not change the default behavior.
When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literals 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. Literals can be delimited by either single or double quotation marks.
Permissions#
Requires membership in the public role.