Posted by Erland Sommarskog on 11/22/07 22:44

Yoda (rmotto@teaminf.com) writes:
> i'm working on a project for convert from a mdb AccessXP(2002)
> application backend to SQL Server Express 2005.
>
> In the past i convertend a similar backend to SQL Server 2000.
>
> My problem is: I have many fields on mdb backend with spaces in field
> name (i know bad thing)
>
> With SQL Server 2000 I had no problem because it recognize the field
> correctly with syntax [field name]
>
> but now with SQL Server Express 2005 i'm experiencing problems....in
> fact it wants to write the field in this way 'field name'.

Where exactly is this happening?

According to the ANSI standard, the proper delimiter for identifiers with
special characters in them is double quote ("). However, SQL Server also
recognizes [], and in my experience, SQL Server strongly favours [] over
"".

Single quotes always delimit string literals.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL Server Express 2005 @@SPID
• Prev in forum: Re: foreign keys - on which kind of keys do the base on?
• Thread view: Re: Upsize from mdb to SQL Express 2005

[Reply to this message]