Content deleted Content added
m v2.05b - Bot T20 CW#61 - Fix errors for CW project (Reference before punctuation) |
Rescuing 1 sources and tagging 0 as dead.) #IABot (v2.0.9.5 |
||
| (2 intermediate revisions by 2 users not shown) | |||
Line 1:
{{Short description|2003 edition of the SQL standard}}
{{SQL language revisions}}
'''SQL:2003''' is the fifth revision of the [[SQL]] [[database]] [[query language]]. The standard consists of 9 parts which are described in detail in [[SQL#Interoperability and standardization|SQL]]. It was updated by [[SQL:2006]].
==New features==
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–126 |archiveurl = https://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|url-access=subscription}}</ref>
* [[XML]]-related features ([[SQL/XML]])
* [[Window function (SQL)|Window functions]]
Line 16 ⟶ 17:
==Documentation availability==
The SQL standard is not freely available but 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] {{Webarchive|url=https://web.archive.org/web/20160330011635/http://www.wiscorp.com/sql_2003_standard.zip |date=2016-03-30 }} 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.
==References==
| |||