Content deleted Content added
a few basic details added to summary, establish the use of refs |
|||
Line 1:
{{dablink|This article is about '''SQL:2008''', a revision of the [[SQL]] standard. For more information about SQL, see the main [[SQL]] article.}}
'''SQL:2008''' is the sixth revision of the [[International Organization for Standardization|ISO]] and [[ANSI]] standard for the [[SQL]] [[database]] [[query language]]. It was formally adopted in July 2008.<ref name="sybase08">[http://iablog.sybase.com/paulley/2008/07/sql2008-now-an-approved-iso-international-standard/ SQL:2008 now an approved ISO International Standard], a July 29th, 2008 blog post from a [[Sybase]] blog</ref>
==Summary==
{{expand section|date=February 2011}}
The SQL:2008 standard is split into several parts, covering the Framework, the Foundation, the [[SQL/CLI|Call-Level Interface]], [[SQL/PSM|Persistent Stored Modules]], [[SQL/MED|Management of External Data]], [[SQL/OLB|Object Language Bindings]], [[SQL/Schemata|Information and Definition Schemas]], [[SQL/JRT|Routines and Types]] Using [[Java (programming language)|Java]], and various "Related Specifications."
Additions to the Foundation include enhanced [[Merge (SQL)|MERGE]] and DIAGNOSTIC statements, the [[Truncate (SQL)|TRUNCATE TABLE]] statement, comma-separated WHEN clauses in a CASE expression, partitioned [[Join (SQL)|join]] tables, support for various [[XQuery]] [[regular expression]]/[[Pattern matching|pattern-matching]] features, and enhancements to derived column names.<ref name="sybase08"/>
==Documentation availability==▼
The
The SQL standard is not freely available. The whole standard may be purchased from the [[International Organization for Standardization|ISO]] as ''ISO/IEC 9075(1-4,9-11,13,14):2008''. The standard consists of the following parts:
* [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=45498 ISO/IEC 9075-1:2008] Framework (SQL/Framework)
Line 18 ⟶ 23:
* [http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=45499 ISO/IEC 9075-14:2008] XML-Related Specifications ([[SQL/XML]])
==References==
<references/>
▲The XML-Related Specifications for SQL:2008, found in ISO/IEC 9075-14:2008, may be purchased from the [[ISO]]. ISO/IEC 9075-14:2008 defines ways in which SQL can be used in conjunction with [[XML]]. It defines ways of importing and storing XML data in an SQL database, manipulating it within the database and publishing both XML and conventional SQL-data in XML form. In addition, it provides facilities that permit applications to integrate into their SQL code the use of [[XQuery]], the XML Query Language published by the [[World Wide Web Consortium]] (W3C), to concurrently access ordinary SQL-data and XML documents.<ref name="9075-14:2008">International Organization for Standardization: "ISO/IEC 9075-14:2008"</ref>
{{SQL}}▼
{{compu-lang-stub}}▼
{{database-stub}}▼
[[Category:SQL| ]]
[[Category:Declarative programming languages]]
[[Category:Query languages]]
[[Category:2008 introductions]]
▲{{SQL}}
▲{{compu-lang-stub}}
▲{{database-stub}}
[[ru:SQL:2008]]
| |||