Posted by Erland Sommarskog on 11/23/07 08:28

Yoda (rmotto@teaminf.com) writes:
> Sorry...my mistake....the syntax i mean is
>
> SELECT "Articoli"."ID ARTICOLO" FROM "Articoli" with double quotesnot
> single quotes
>
> I just want to know if SQL Express 2005 can work the same way SQL 2000
> works....with [] instead of ""
>
> I think the problem is related to Access Frontend....because if i use
> New Query From Management Studio Express it works with []

Yes, SQL Express can use []. Why you get double quotes in Access I have
no idea - then again, Access is a product of which I have no knowledge.
You may get better help with Access-specific questions in an Accesss
newsgroup.


--
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 injecting
• Prev in forum: Re: Upsize from mdb to SQL Express 2005
• Thread view: Re: Upsize from mdb to SQL Express 2005

[Reply to this message]