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.
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.
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.