Access to SQL - Newbie to SQL

[eStudio]

I'm making the big switch on several sites from Access to SQL and wanted to see if anyone would like to submit some words of wisdom, suggestions, tips, etc.???


TIA,
Donna

[randem]

Dates in Access are written as #1/1/2000# while in SQL Server, they are written as in '1/1/2000'

Some of the names of the column types are different, and SQL Server offers more column types.

Syntax is quite a bit different going from Access Queries to SQL Server Stored Procedures.


...hope this helps...