WHAT DOES IT MEAN TO HAVE QUOTED_IDENTIFIER ON? WHAT ARE THE IMPLICATIONS OF HAVING IT OFF?

Awadhendra Tiwari

Total Post:510

Points:2550
Posted by  Awadhendra Tiwari
 1370  View(s)
Ratings:
Rate this:
  1. Awadhendra Tiwari

    Post:510

    Points:2550
    What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!