Ansi SQL 1

[Patten]

Hey,

I'm looking for information about the official ANSI SQL, independant from the database platform. The purpose is to develop an application which is independant of the choice of database platform. So all the SQL statements should match the ANSI SQL standard, as it is supported by most of the database vendors (I suppose so...). But where can I find this official version of ANSI SQL (website?, books?).

 

[dnoeth]

You can spend a lot of money to buy the standard documents from ISO (

http://www.iso.org),

but IMHO it's almost impossible to read/understand it.

You can get the latest drafts of SQL:2003 as PDFs at
ftp://sqlstandards.org/SC32/WG3/Progression_Documents/FDIS

SQL92 and SQL:1999
ftp://sqlstandards.org/SC32/WG3/Progression_Documents/IS

Maybe it's better to look at some books about standard SQL:
SQL:1999 by Jim Melton
SQL-99 Complete, Realy by Gulutzan/Pelzer

"So all the SQL statements should match the ANSI SQL standard, as it is supported by most of the database vendors"

Good joke ;-)
All the big DBMSes only support a subset of the standard, i.e. SQL92 Entry Level plus some parts from higher levels plus proprietary extensions.
No DBMS supports SQL:1999 Core Level yet.

To check for ANSI compliance you can use the SQL Validator website at

http://developer.mimer.com/validator/index.htm

Dieter

 

[JarlH]

A great tool when developing database independent applications is the SQL Validator. Check it out at:

http://developer.mimer.com/validator/

It has support for SQL-92, SQL-99, and even SQL-2003 (draft).


/Jarl