:::: MENU ::::

Quoted Identifier Enabled (QUOTED_IDENTIFIER) in SQL Server T-SQL

  • Nov 05 / 2008
  • 0
dbDigger, T-SQL Interview Questions

Quoted Identifier Enabled (QUOTED_IDENTIFIER) in SQL Server T-SQL

Quoted Identifier option controls the interpretation of double quotation marks by the parser. When set to TRUE in SQL Server Management Studio or ON when using the ALTER DATABASE command, double quotation marks can be used to enclose delimited identifiers, for example, FirstName = “Mike”.
When set to FALSE, identifiers cannot be in quotation marks and must follow all T-SQL rules for identifiers.

Consult us to explore the Databases. Contact us