SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: Access to SQL - Newbie to SQL
-
Jul 11, 2002, 14:18 #1
- Join Date
- Dec 2001
- Location
- NE Texas
- Posts
- 153
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Access to SQL - Newbie to SQL
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
-
Jul 11, 2002, 14:26 #2
- Join Date
- Jun 2002
- Location
- .chicago.il.us
- Posts
- 957
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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...
Bookmarks