Developer Forum

by **Juliano Pr** » Wed, 12 May 2004 21:08:12

Hi,

Does anyone knows where I can download the complete ANSI SQL 92
especification ?
Thanks in advance.

Juliano

by **Bojidar Al** » Wed, 12 May 2004 22:08:56

You have to buy it....

by **Craig Stun** » Wed, 12 May 2004 22:43:33

And it's expensive and somewhat impenetrable to read. There are
"plain English" books about the standard which are both cheaper and
easier to read.

-Craig

--
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : http://www.yqcomputer.com/
How to ask questions the smart way:
http://www.yqcomputer.com/ ~esr/faqs/smart-questions.html

by **Juliano Pr** » Wed, 12 May 2004 23:40:28

I will look for these books.
Thanks for helping.

Juliano

by **Arno Brink** » Fri, 14 May 2004 16:34:24

Hi,

Google for "sql1992.txt" :-)

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.yqcomputer.com/
http://www.yqcomputer.com/
http://www.yqcomputer.com/
http://www.yqcomputer.com/

Support list for Interbase and Firebird users :
XXXX@XXXXX.COM

Nederlandse firebird nieuwsgroep :

by **jarl** » Sat, 15 May 2004 16:50:00

Juliano,

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.yqcomputer.com/

However, there's an SQL-92 draft available on the Internet:
http://www.yqcomputer.com/ ~shadow/sql/sql1992.txt

If you just want to verify standard compliance, check out the SQL
Validator. It supports SQL-92, SQL-99, and even SQL-2003:

http://www.yqcomputer.com/

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.yqcomputer.com/
http://www.yqcomputer.com/

742 2002.01.15 ISO/IEC FCD 9075-1:200x Information technology -
Database Languages - SQL - Part 1: Framework (SQL/Framework)
http://www.yqcomputer.com/ $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.yqcomputer.com/ $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.yqcomputer.com/ $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.yqcomputer.com/ $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.yqcomputer.com/ $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.yqcomputer.com/ $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.yqcomputer.com/ $FILE/32N0748T.PDF

Regards,
Jarl