×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ANSI_SQL FAQ

ANSI SQL Guidelines

What is ANSI SQL? Why This Forum? by tlbroadbent
Posted: 5 Sep 01 (Edited 4 Feb 03)

The ANSI SQL forum exists to discuss programming in Structured Query Language (SQL), independent of a specific implementation or RDMS. SQL is a widely used language for data retrieval and manipulation in databases.

In 1989, the American National Standards Institute (http://www.ansi.org) published a SQL specification. The ANSI SQL standard was revised in 1992 and this is often referred to as SQL-92 or SQL-2. View the SQL-92 standards draft document.

http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

SQL-99 or SQL:1999 is the current standard. SQL-99 is sometimes called SQL-3.

The latest standard is SQL:2003 or SQL:200n. This standard is currently under development. You can download the SQL:200n working documents from Whitemarsh Information Systems Corp.

http://www.wiscorp.com/sql/SQL200nFCD.zip

Several revisions of the SQL Standards working documents are available from the SQL Standards Organization website.

ftp://sqlstandards.org/SC32/WG3/Progression_Documents/Informal_working_drafts/

Most major database vendors support the SQL-92 standard. However, the levels of conformance vary. Some vendors have gone beyond the SQL-92 standard and most have their own extensions to the SQL language.

Michael Gorman wrote an article, ôIs Sql A Real Standard Anymore?,ö  for the April 2001 issue of ôThe Data Administration Newsletterö from TDAN.

http://www.tdan.com/i016hy01.htm

Peter Gulutzan authored an article on the ôSQL Standardö for the Jan. 2003 issue of ôThe Data Administration Newsletterö from TDAN.

http://www.tdan.com/i023fe03.htm

More articles related to SQL can be found at

http://www.netaktive.com/biblio/sql/SQL98/standards.html
http://www.wiscorp.com/SQLStandards.html
http://www.jcc.com/SQLPages/jccs_sql.htm
http://linux.oreillynet.com/pub/a/linux/2000/10/20/aboutSQL_1.html
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql2bnf.aug92.txt

The United States Federal Information Processing Standards Publication, ôStandard for Database Language SQLö can be downloaded from http://www.itl.nist.gov/fipspubs/fip127-2.htm.
__________________________________________________

A number of database forums exist on Tek-Tips where database or RDMS specific questions can be answered. As mentioned, most database products do not fully comply with the ANSI SQL-92 or SQL-99 standards. As a result, an ANSI SQL solution may not work in a particular database. Therefore, if you use one of the products listed below and your question pertains to the product, you'll probably get an answer more quickly in a forum for that product.
__________________________________________________

Forum177 Corel: Paradox Forum
Forum178 IBM: DB2 Forum
Forum179 Informix: Informix Dynamic Server Forum
Forum181 Microsoft: Access General discussion Forum
Forum701 Microsoft: Access Queries and Access/SQL Forum
Forum183 Microsoft: SQL Server Forum
Forum259 Oracle: Developer Forum
Forum119 Oracle: Enterprise Developer Suite Forum
Forum185 Oracle: Oracle release 5, 6, and 7 Forum
Forum186 Oracle: Oracle release 8 and 8i Forum
Forum759 Oracle: Oracle release 9i Forum
Forum318 Pervasive: Pervasive.SQL Forum
Forum699 PostgreSQL Inc: PostgreSQL Forum
Forum188 Sybase: SQL Server Forum
Forum352 Sylvain Faust, Intl (SFI): SQL-Programmer Forum
Forum436 T.C.X DataKonsult AB: MySQL Forum

__________________________________________________

Please feel free to comment, suggest revisions and/or additional forums to include in the list.

Back to ANSI_SQL FAQ Index
Back to ANSI_SQL Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close