SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot eStudio's Avatar
    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

  2. #2
    morphine for a wooden leg randem's Avatar
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •