Post reply

What is the Use of QUOTED_IDENTIFIER

  • March 13, 2008 at 6:33 am

    #184136

    Hi,

    What is the Use of QUOTED_IDENTIFIER? why why do we use this in storedprocedure? what is the working of this?

  • March 13, 2008 at 7:42 am

    #789037

    The default setting for QUOTED_IDENTIFIER is to ON. This provides the ability to enclose column and table identifiers in double quote marks to define an identifier. The biggest use I have seen for setting QUOTED_IDENTIFIER to OFF is to provide the ability to delimite string literals with double quotes marks.

    years ago I would sometimes turn QUOTED_IDENTIFIER off so that I could use the double quote delimited literals; however, this something I no longer use because it puts the connection in a state where it is not "ansi compliant." (Will someone check me on this please?)

  • March 13, 2008 at 7:55 am

    #789047

    You can read about it in Books Online, but as Kent mentioned, it's to handle objects that have names with quotes in them.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply