Access SQL vs SQLServer 7 SQL

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I looking for any info all differences between SQL clauses and such between SQL used for Access And that for SQLServer 7. Such as the differences in using '*'.

Thanks

-- Anonymous, November 23, 1998

Answers

Access SQL vs SQL Server 7 SQL

Justin,

I presume you are considering migrating to SQL Server 7.0. If so, here are some issues that might come up as you migrate the select statements.

String functions are different.

Date formats are different.

Money formats are different.

SQL Server does not have field-validation like Access; the upsizing wizard will convert the field validations to insert and update triggers.

SQL Server does not like blanks in field names.

By the way, the upsizing wizard doesn't work with SQL Server 7 Beta 3 because of DMO differences between the two versions. Access 97 to SQL 6.5 to SQL 7.0 should work.

Hope this helps,

Eric

-- Anonymous, November 30, 1998


Moderation questions? read the FAQ