Results 1 to 5 of 5

Thread: Sql

  1. #1
    Join Date
    Aug 2002
    Location
    Albuquerque, NM
    Posts
    2

    Question Unanswered: Sql

    What is the advantage of SQL over MS Access and when is it better to use MS Access? I've been doing Access databases & would like to learn more about SQL so I can advance myself in my organization.

  2. #2
    Join Date
    Jul 2002
    Posts
    67

    Re: Sql

    Originally posted by abq4me
    What is the advantage of SQL over MS Access and when is it better to use MS Access? I've been doing Access databases & would like to learn more about SQL so I can advance myself in my organization.
    Are you referring to SQL(Structured Query Language) or SQL Server?
    Don't do today, what can be done tomorrow.

  3. #3
    Join Date
    Aug 2002
    Location
    Albuquerque, NM
    Posts
    2
    Structured Query Language (Oracle probably).

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    abq4me, if you want to learn SQL the language, microsoft access will get you 90% of the way, because access uses SQL

    if your company "probably" uses oracle, learn that

    if your company uses microsoft sql/server, learn that

    these database systems all use SQL

    also, it depends what you want to do -- understand and analyze user information requests, or tune a server for maximum performance (opposite extremes of database skills, and usually mutually exclusive)

    rudy
    http://rudy.ca/

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    I think you might be a little confused between sql and the different extensions of sql that each provider modifies and enhances for their own database. Standard sql is based on ansi-sql 92 - but each database provides enhancements - for sql server it is called tsql; for oracle it is called pl/sql ...

Posting Permissions

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