Posted by Yoda on 11/23/07 07:36

On 22 Nov, 23:44, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Yoda (rmo...@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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Hi,
my frontend is AccessXP(2002) my backend is SQL Express 2005. In the
rowsource of a combobox or even in view or sp design I can wirte SQL
Statement only in this way 'field name' ......it doesn't recognize
correctly [field name].
This is not valid for SQL 2000 in which i can use [field name].

Thank u

[Back to original message]