Quoted identifier

On the Options tab in database properties, there is an option of Use quoted
identifiers,
does anyone knows the option of this for what purpose and any example ?Connection settings, such as quoted identifiers, can be set at the
connection, database or server level:
1) connection: SET QUOTED_IDENTIFIER ON
2) database: Enterprise Manager database properties or
ALTER DATABASE MyDatabase
SET QUOTED_IDENTIFIER ON
3) server: EXEC sp_configure 'user options', 256
Settings at the connection level override database and server settings.
Setting at the database level override the server specification.
When quoted identifiers is on (the ANSI standard), double quotes can be used
to enclose identifiers and single quotes are used for literal strings. OLE
DB and ODBC APIs set QUOTED_IDENTIFIER ON when connecting.
See the Books Online for details.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:usKgtRpqEHA.3980@.TK2MSFTNGP12.phx.gbl...
> On the Options tab in database properties, there is an option of Use
> quoted
> identifiers,
> does anyone knows the option of this for what purpose and any example ?
>