SQL:2008: Difference between revisions

Revision as of 22:25, 21 February 2010

Latest revision as of 10:47, 4 February 2025

(32 intermediate revisions by 26 users not shown)

Line 1:

{{Short description|2008 edition of the SQL standard}}

{{dablink|This article is about '''SQL:2008''', a revision of the [[SQL]] standard. For more information about SQL, see the main [[SQL]] article.}}

{{SQL language revisions}}

{{about|the language standard|''MS SQL 2008'', the Microsoft product|Microsoft SQL Server 2008}}

'''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] {{webarchive|url=https://web.archive.org/web/20110628130925/http://iablog.sybase.com/paulley/2008/07/sql2008-now-an-approved-iso-international-standard/ |date=2011-06-28 }}, 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]]. The next iteration is [[SQL:2011]]

==New features==

'''SQL:2008''' is the sixth revision of the [[SQL]] [[database]] [[query language]].

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"/>

==SummaryDocumentation ==

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:

The SQL:2008 standard was published in 2008.

==Claims of conformance==

==Documentation availability==

The minimum level of conformance to SQL:2008 that a product can claim is called "Core SQL:2008" and is limited to definitions specified in two parts of the standard: the Foundation and the Information and Definition Schemas.<ref>[https://docs.oracle.com/cd/E11882_01/server.112/e41084/ap_standard_sql003.htm#SQLRF55516 Oracle Compliance To Core SQL:2008] from [[Oracle Corporation]]</ref>

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)

* [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]])

==See also==

<!-- Commented out, same things found in [[SQL/XML]]?

{{Wikibook|Structured Query Language}}

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>

*[[Structured Query Language]]

-->

==References==

<references />

==External links==

*[http://www.wiscorp.com/SQLStandards.html Freely downloadable drafts of this standard]

[[Category:SQL| ]]

[[Category:Declarative programming languages]]

[[Category:Query languages]]

[[Category:2008 introductions]]

{{SQL}}

{{compu-lang-stub}}

{{database-stub}}

[[ruCategory:SQL:2008|* ]]

[[Category:Declarative programming languages]]

[[Category:SQL|Query languages]]

[[Category:2008Computer-related introductions in 2008]]