Posted by Steve Kass on 08/13/05 06:06

Many simple queries will be the same in SQL Server. The main difference
I know of is that Access supports more proprietary syntax. Some of the
Access keywords that are not available in SQL Server include PIVOT,
TRANSFORM, FIRST, LAST, and DISTINCTROW.

Steve Kass
Drew University


John wrote:

> I have database in Access with queries in database.
> Are syntax of queries in Access same as syntax of queries in MS SQL 2000, so
> that I dont have to change every query?
> I can post sample query if needed.
>
> Thanks!!
>
>

[Back to original message]