>From the SQL2000 Books Online (in the index look for quoted identifiers and
select system configuration):
Quoted Identifiers
Note Quoted identifiers are used by default in SQL Server 2000, that is,
they are set to ON. This is different from SQL Server 7.0 where they were
set to OFF by default.
The QUOTED_IDENTIFIER setting determines what meaning Microsoft SQL Server
gives to double quotation marks ("). When QUOTED_IDENTIFIER is set to OFF,
double quotation marks delimit a character string, just as single quotation
marks do. When QUOTED_IDENTIFIER is set to ON, double quotation marks
delimit an identifier, such as a column name. An identifier must be enclosed
in double quotation marks; for example, if its name contains characters that
are otherwise not allowed in an identifier, including spaces and
punctuation, or if the name conflicts with a reserved word in Transact-SQL.
Regardless of the QUOTED_IDENTIFIER setting, an identifier can also be
delimited by square brackets.
The meaning of the following statement, for example, depends on whether
QUOTED_IDENTIFIER is set to ON or OFF:
SELECT "x" FROM T
If QUOTED_IDENTIFIER is set to ON, "x" is interpreted to mean the column
named x. If it is set to OFF, "x" is the constant string x and is equivalent
to the letter x.
If the previous SELECT statement example were part of a stored procedure
created when QUOTED_IDENTIFIER was set to ON, then "x" would always mean the
column named x. Even if the QUOTED_IDENTIFIER setting was later switched,
and set to OFF, the stored procedure would respond as if it were set to ON
and treat "x" as the column named x.
Bill Grover
Supervisor, IS
EU Services, Inc.
649 N Horners Ln
Rockville MD 20850
Phone: 301-424-3300 x396
FAX: 301-424-3300 x1396#
E-Mail: [EMAIL PROTECTED]
> -----Original Message-----
> From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 14, 2001 9:59 AM
> To: CF-Talk
> Subject: SQL 2000
>
>
> Anyone here upgraded to SQL 2000 and found that when you try
> to release an
> SP that uses double quotes to build a string it complains,
> wheras it was
> fine in SQL 7? Is there a server or console setting that
> gets around this?
>
>
> ------------------------------------------------------------------
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> http://www.thoughtbubble.net
> ------------------------------------------------------------------
> United Kingdom
> http://www.thoughtbubble.co.uk/
> Tel: +44 (0) 20 7387 8890
> ------------------------------------------------------------------
> New Zealand
> http://www.thoughtbubble.co.nz/
> Tel: +64 (0) 9 488 9131
> ------------------------------------------------------------------
> The information in this email and in any attachments is
> confidential and
> intended solely for the attention and use of the named
> addressee(s). Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further
> distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy,
> distribute, or
> retain this message. Please notify us on +44 (0)207 387 8890.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
