SQL:2003: Difference between revisions
Content deleted Content added
Entranced98 (talk | contribs) Importing Wikidata short description: "2003 edition of the SQL standard" |
Citation bot (talk | contribs) Altered pages. | Use this bot. Report bugs. | Suggested by Abductive | Category:SQL | #UCB_Category 33/76 |
||
| Line 3: | Line 3: | ||
==New features== |
==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= |
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}}</ref> |
||
* [[XML]]-related features ([[SQL/XML]]) |
* [[XML]]-related features ([[SQL/XML]]) |
||
* [[Window function (SQL)|Window functions]] |
* [[Window function (SQL)|Window functions]] |
||
Revision as of 08:16, 26 July 2024
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. 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:[1]
- XML-related features (SQL/XML)
- Window functions
- the sequence generator, which allows standardized sequences
- two new column types: auto-generated values and identity-columns
- the new MERGE statement
- extensions to the CREATE TABLE statement, to allow "CREATE TABLE AS" and "CREATE TABLE LIKE"
- removal of the poorly implemented "BIT" and "BIT VARYING" data types
- OLAP capabilities (initially added in SQL:1999) were extended with a window function.[2]
Documentation availability
The SQL standard is not freely available but may be purchased from ISO or ANSI. A late draft is available as a zip archive from Whitemarsh Information Systems Corporation. The zip archive contains a number of PDF files that define the parts of the SQL:2003 specification.
References
- ^ Eisenberg, Andrew; et al. (March 2004). "SQL:2003 Has Been Published". SIGMOD Record. 33 (1): 119–126. doi:10.1145/974121.974142. Archived from the original (pdf) on 2007-11-11. Retrieved 2007-08-14.
- ^ Christian S. Jensen; Torben Bach Pedersen; Christian Thomsen (2010). Multidimensional Databases and Data Warehousing. Morgan & Claypool Publishers. p. 26. ISBN 978-1-60845-537-9.
External links
- BNF Grammar for ISO/IEC 9075:2003 – SQL/Framework