Jump to content

SQL:2003: Difference between revisions

From Wikipedia, the free encyclopedia
Content deleted Content added
clean up using AWB
Line 32: Line 32:
* [http://savage.net.au/SQL/sql-2003-1.bnf.html BNF Grammar for ISO/IEC 9075-1:2003] – '''SQL/Framework'''
* [http://savage.net.au/SQL/sql-2003-1.bnf.html BNF Grammar for ISO/IEC 9075-1:2003] – '''SQL/Framework'''
* [http://savage.net.au/SQL/sql-2003-2.bnf.html BNF Grammar for ISO/IEC 9075-2:2003] – SQL/Foundation
* [http://savage.net.au/SQL/sql-2003-2.bnf.html BNF Grammar for ISO/IEC 9075-2:2003] – SQL/Foundation
{{SQL}}

{{DEFAULTSORT:Sql:2003}}
{{DEFAULTSORT:Sql:2003}}
[[Category:SQL| ]]
[[Category:SQL| ]]

Revision as of 22:25, 21 February 2010

SQL:2003 is the fifth revision of the SQL database query language. The latest revision of the standard is SQL:2008.

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:[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

Documentation availability

The SQL standard is not freely available. SQL:2003 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

  1. ^ Eisenberg, Andrew (2004). "SQL:2003 Has Been Published" (pdf). SIGMOD Record. 33 (1): 119. doi:10.1145/974121.974142. Retrieved 2007-08-14. {{cite journal}}: Unknown parameter |coauthors= ignored (|author= suggested) (help); Unknown parameter |month= ignored (help)