SQL:2003

From Seo Wiki - Search Engine Optimization and Programming Languages

Jump to: navigation, search

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

Contents

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; et al. (March 2004). "SQL:2003 Has Been Published" (pdf). SIGMOD Record 33 (1): 119. doi:10.1145/974121.974142. http://www.acm.org/sigmod/record/issues/0403/index.html#standards. Retrieved 2007-08-14. 

External links


es:SQL:2003

ru:SQL:2003

Personal tools

Served in 0.142 secs.