SQL:2003: Difference between revisions

Revision as of 08:41, 22 December 2016

Revision as of 16:36, 21 January 2017

Line 1:

{{dablink|This article is about '''SQL:2003''', ais the fourth revision of the [[SQL]] standard[[database]] [[query language]]. ForThe morestandard informationconsists aboutof SQL,9 seeparts thewhich mainare described in detail in [[SQL#Interoperability_and_standardization|SQL]]. In the meanwhile '''SQL:2003''' is articledeprecated.}}

==New Features==

'''SQL:2003''' is the fourth revision of the [[SQL]] [[database]] [[query language]]. The latest revision of the standard is [[SQL:2011]].

==Summary==

The SQL:2003 standard makes minor modifications to all parts of [[SQL:1999]] (also known as SQL3), and officially introduces a few new features such as:<ref>{{cite journal|url=http://www.acm.org/sigmod/record/issues/0403/index.html#standards|last=Eisenberg|first=Andrew|title=SQL:2003 Has Been Published|format=pdf|journal=SIGMOD Record|volume=33|issue=1|date=March 2004|accessdate=2007-08-14|doi=10.1145/974121.974142|pages=119 |archiveurl = http://web.archive.org/web/20071111200042/http://www.acm.org/sigmod/record/issues/0403/index.html#standards <!-- Bot retrieved archive --> |archivedate = 2007-11-11|display-authors=etal}}</ref>

* [[XML]]-related features ([[SQL/XML]])

Line 15 ⟶ 13:

==Documentation availability==

The SQL standard is not freely available. SQL:2003but may be purchased from [http://www.iso.org/ ISO] or [http://webstore.ansi.org/ ANSI]. A late draft is available as a [http://www.wiscorp.com/sql_2003_standard.zip zip archive] from [http://www.wiscorp.com/ Whitemarsh Information Systems Corporation]. The zip archive contains a number of [[Portable Document Format|PDF]] files that define the parts of the SQL:2003 specification.

* ISO/IEC 9075(1-4,9-11,13,14):2003 CD-ROM (352 [[Swiss franc|CHF]], or approximately 225 [[Euro|EUR]], to order the CD)

** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34132 ISO/IEC 9075-1:2003] &ndash; Framework (SQL/Framework)

** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34133 ISO/IEC 9075-2:2003] &ndash; Foundation (SQL/Foundation)

** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34134 ISO/IEC 9075-3:2003] &ndash; Call-Level Interface (SQL/CLI)

** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34135 ISO/IEC 9075-4:2003] &ndash; Persistent Stored Modules (SQL/PSM)

** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34136 ISO/IEC 9075-9:2003] &ndash; Management of External Data (SQL/MED)

** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34137 ISO/IEC 9075-10:2003] &ndash; Object Language Bindings (SQL/OLB)

** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=34917 ISO/IEC 9075-11:2003] &ndash; Information and Definition Schemas (SQL/Schemata)

** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=37102 ISO/IEC 9075-13:2003] &ndash; SQL Routines and Types Using the [[Java (programming language)|Java]] Programming Language (SQL/JRT)

** [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=35341 ISO/IEC 9075-14:2003] &ndash; XML-Related Specifications (SQL/XML)

==References==