Sqlserver: Set quoted_identifier

These setting statements are automatically included in the System wizard.

Syntax setQuoted_identifier{On | off}

1. enable SQL Server to follow the ISO rules for the quotation mark separator and text string.

2 when setQuoted_identifierWhen it is on (default), the identifiers can be separated by double quotation marks, and the text must be separated by single quotation marks. When setQuoted_identifierWhen it is off, the identifier cannot be enclosed in quotation marks and must comply with all the rules of the transact-SQL identifier.

3. When you create or change an index on a calculated column or index view, SetQuoted_identifierMust be on. If setQuoted_identifierIf it is off, the CREATE, update, insert, and delete statements on the table with indexes on the calculation column or index view will fail.

4 setQuoted_identifierIt is set during analysis. Setting during analysis means that the Set statement takes effect as long as it appears in a batch or stored procedure, and is irrelevant to whether the code execution actually reaches this point. The set statement takes effect before any statement is executed.

5 SQL: Create Table "Update" must be set to on with double quotation marks. Otherwise, an error is returned.

6 RequirementsPublicThe role's membership identity.