SQL:2008: Difference between revisions

Revision as of 17:36, 31 January 2009

Latest revision as of 10:47, 4 February 2025

(40 intermediate revisions by 31 users not shown)

Line 1:

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

{{dablink|This article is about '''SQL:2006''', 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:2006''' 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 standards documentation is not freely available but may be purchased from the [[International Organization for Standardization|ISO]] as ''ISO/IEC 9075(1-4,9-11,13,14):2008''.

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 XML-Related Specifications for SQL:2006, found in ISO/IEC 9075-14:2006, may be purchased from the [[ISO]]. ISO/IEC 9075-14:2006 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:2006">International Organization for Standardization: "ISO/IEC 9075-14:2006"</ref>

==NotesSee also==

{{Wikibook|Structured Query Language}}

{{reflist|1}}

*[[Structured Query Language]]

==References==

<references />

*{{cite web

| last = International Organization for Standardization

| first =

| authorlink = ISO

| coauthors =

| title = ISO/IEC 9075-14:2006

| work = ISO/IEC 9075-14:2006 Information technology -- Database languages -- SQL -- Part 14: XML-Related Specifications (SQL/XML)

| publisher =

| date =

| url = http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=38647

| format =

| doi =

| accessdate = 2008-03-05 }}

==External links==

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

[[Category:SQL| ]]

{{SQL}}

[[Category:SQL|* ]]

[[Category:Declarative programming languages]]

[[Category:Query languages]]

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

{{compu-lang-stub}}

{{database-stub}}