Posted by Plamen Ratchev on 04/19/07 05:13

There are two ways to handle special characters (or reserved keywords) in
identifiers (databases, tables, other object names, etc.):


- using brackets [], like this (the example below includes some other
objects like database and table names with special characters):

SELECT [My Column] FROM [My~Database].[My^User^ID].[My$Table]


- using double quotation marks (this is the SQL-92 syntax), like this:

SELECT "My Column" FROM "My~Database"."My^User^ID"."My$Table"

In order to use the double quotation marks the QUOTED_IDENTIFIER option has
to be ON. You can do that in Query Analyzer by running:

SET QUOTED_IDENTIFIER ON


It is not a good practice to use special characters in identifiers as it
makes code difficult to read and maintain.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: Snapshot of databases = Hourly job
• Prev in forum: RESTORE DATABASE is terminating abnormally.
• Thread view: Re: Column naming/spacing

[Reply to this message]