Re: SQL standard

"Randi W" <randiwolner_at_hotmail.com> wrote in message news:<ck0uk3$4m0$1_at_services.kq.no>...
> In my application I am trying to use only SQLs that can be run on 'any'
> database.
> Can anyone tell me where I can find the SQL standard (ANSI)? I guess it is
> published somewhere on the internet?
> Is SQL-92 the 'newest' one, that I should use as reference when having these
> wishes?
>
> Thanks,
> Randi

Randi,

ISO/ANSI doesn't publish their standards on the Internet. You'll have to buy them. The current version of the SQL standard is SQL-2003, so that's the version of the standard ISO will offer you.

If you want, you can by your own copy directly from ISO: http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER= 34132&ICS1=35&ICS2=60&ICS3= If you just want to verify standard compliance, check out the SQL Validator, an online tool verifying your SQL statements standard compliance. It supports SQL-92, SQL-99, and even SQL-2003: http://developer.mimer.com/validator/index.htm

The SQL validator will save you lots of time and trouble when writing portable applications.

There's an SQL-92 draft available on the Internet: http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

Final committe drafts (FCD) of SQL-2003 are available from the links below. The core parts of SQL has not changed much between SQL-99 and SQL-2003, so these documents are pretty good.

http://www.jtc1sc32.org
http://www.jtc1sc32.org/sc32/jtc1sc32.nsf/DocView750?OpenView&Count=20

742 2002.01.15 ISO/IEC FCD 9075-1:200x Information technology - Database Languages - SQL - Part 1: Framework (SQL/Framework) http://www.jtc1sc32.org/sc32/jtc1sc32.nsf/Attachments/92E811979ED58F4D882 56B410063BA85/$FILE/32N0742T.PDF 743 2002.01.15 ISO/IEC FCD 9075-2:200x Information technology - Database Languages - SQL - Part 2: Foundation (SQL/Foundation) SC 32 Secretariat Text for FCD Ballot
http://www.jtc1sc32.org/sc32/jtc1sc32.nsf/Attachments/43059FE5F9575FB1882 56B41006418C1/$FILE/32N0743T.PDF 744 2002.-1.15 ISO/IEC FCD 9075-3:200x Information technology - Database Languages - SQL - Part 3: Call-Level Interface (SQL/CLI) SC 32 Secretariat Text for FCD Ballot
http://www.jtc1sc32.org/sc32/jtc1sc32.nsf/Attachments/7E3B41486BD99C34882 56B410064C877/$FILE/32N0744T.PDF 745 2002.01.15 ISO/IEC FCD 9075-4:200x Information technology - Database Languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) SC 32 Secretariat Text for FCD Ballot
http://www.jtc1sc32.org/sc32/jtc1sc32.nsf/Attachments/F30153FA0C4ACA19882 56B4100652674/$FILE/32N0745T.PDF 746 2002.01.15 ISO/IEC FCD 9075-9:200x Information technology - Database Languages - SQL - Part 9: Management of External Data (SQL/MED) SC 32 Secretariat Text for FCD Ballot http://www.jtc1sc32.org/sc32/jtc1sc32.nsf/Attachments/5C70E57D0CC2EF6D882 56B41006577A4/$FILE/32N0746T.PDF 747 2002.01.15 ISO/IEC FCD 9075-10:200x Information technology - Database Languages - SQL - Part 10: Object language bindings (SQL/OLB) SC 32 Secretariat Text for FCD Ballot
http://www.jtc1sc32.org/sc32/jtc1sc32.nsf/Attachments/D6C3CD77EEB9B7DF882 56B410065CD34/$FILE/32N0747T.PDF 748 2002.01.15 ISO/IEC FCD 9075-11:200x Information technology - Database Languages - SQL - Part 11: Information and Definition Schemas (SQL/Schemata) SC 32 Secretariat Text for FCD Ballot http://www.jtc1sc32.org/sc32/jtc1sc32.nsf/Attachments/55AA386588D7DDA1882 56B410066203E/$FILE/32N0748T.PDF HTH,
Jarl Received on Wed Oct 06 2004 - 14:23:23 CDT