'''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> The standard consists of 9 parts which are described in detail in [[SQL#Interoperability_and_standardization|SQL]].▼{{About|SQL:2008, a revision of the SQL standard|background information about the SQL query language|SQL}}
▲'''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."
==New Features==
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,
*INSTEAD OF [[database trigger]]s,
*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"/>
The Related Specifications for XML defines ways in which SQL can be used in conjunction with [[XML]], including 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.<ref name="9075-14:2008">International Organization for Standardization: "ISO/IEC 9075-14:2008"</ref>
==Documentation ==
The SQL standardstandards documentation is not freely available. The whole standardbut 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)
*[http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=38640 ISO/IEC 9075-2:2008] Foundation (SQL/Foundation)
*[http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=38641 ISO/IEC 9075-3:2008] Call-Level Interface ([[SQL/CLI]])
*[http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=38642 ISO/IEC 9075-4:2008] Persistent Stored Modules ([[SQL/PSM]])
*[http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=38643 ISO/IEC 9075-9:2008] Management of External Data ([[SQL/MED]])
*[http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=38644 ISO/IEC 9075-10:2008] Object Language Bindings ([[SQL/OLB]])
*[http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=38645 ISO/IEC 9075-11:2008] Information and Definition Schemas ([[SQL/Schemata]])
*[http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=38646 ISO/IEC 9075-13:2008] SQL Routines and Types Using the Java TM Programming Language ([[SQL/JRT]])
*[http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=45499 ISO/IEC 9075-14:2008] XML-Related Specifications ([[SQL/XML]])
==Claims of conformance==
| 