SQL:2008 - Wikipedia

This article is about the language standard. For MS SQL 2008, the Microsoft product, see Microsoft SQL Server 2008.

SQL:2008 is the sixth revision of the ISO and ANSI standard for the SQL database query language. It was formally adopted in July 2008.^[1] The standard consists of 9 parts which are described in detail in SQL. The next iteration is SQL:2011

New features[edit]

Additions to the Foundation include

• enhanced MERGE and DIAGNOSTIC statements,
• the TRUNCATE TABLE statement,
• comma-separated WHEN clauses in a CASE expression,
• INSTEAD OF database triggers,
• partitioned JOIN tables,
• support for various XQuery regular expression/pattern-matching features, and
• enhancements to derived column names.^[1]

Documentation[edit]

The SQL standards documentation is not freely available but may be purchased from the ISO as ISO/IEC 9075(1-4,9-11,13,14):2008.

Claims of conformance[edit]

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.^[2]

See also[edit]

• Wikibook SQL

References[edit]

External links[edit]

• Freely downloadable drafts of this standard