SQL:2008: Difference between revisions

Revision as of 13:23, 10 August 2017

Latest revision as of 10:47, 4 February 2025

(10 intermediate revisions by 9 users not shown)

Line 1:

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

'''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]].

{{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 Featuresfeatures==

Additions to the Foundation include

*enhanced [[Merge (SQL)|MERGE]] and DIAGNOSTIC statements,

Line 9 ⟶ 12:

*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 ==

Line 18 ⟶ 21:

==See also==

*[[b:{{Wikibook|Structured Query Language|Wikibook SQL]]}}

*[[Structured Query Language]]

==References==

Line 28 ⟶ 32:

{{SQL}}

[[Category:SQL|* ]]

[[Category:Declarative programming languages]]

[[Category:Query languages]]

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