SQL:2003

SQL:2003 is the fourth 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

  1. ^ Eisenberg, Andrew; et al. (March 2004). "SQL:2003 Has Been Published". SIGMOD Record. 33 (1): 119. doi:10.1145/974121.974142. Archived from the original (pdf) on 2007-11-11. Retrieved .
  2. ^ 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


  This article uses material from the Wikipedia page available here. It is released under the Creative Commons Attribution-Share-Alike License 3.0.

SQL:2003
 



 

Connect with defaultLogic
What We've Done
Led Digital Marketing Efforts of Top 500 e-Retailers.
Worked with Top Brands at Leading Agencies.
Successfully Managed Over $50 million in Digital Ad Spend.
Developed Strategies and Processes that Enabled Brands to Grow During an Economic Downturn.
Taught Advanced Internet Marketing Strategies at the graduate level.


Manage research, learning and skills at defaultlogic.com. Create an account using LinkedIn to manage and organize your omni-channel knowledge. defaultlogic.com is like a shopping cart for information -- helping you to save, discuss and share.


  Contact Us