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 2011

## Contents

* 1 New features
* 2 Documentation
* 3 Claims of conformance
* 4 See also
* 5 References
* 6 External links

## New features

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

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

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

| Wikibooks has a book on the topic of: Structured Query Language

|

* Structured Query Language

## References

1. ↑ 1.0 1.1 SQL:2008 now an approved ISO International Standard , a July 29th, 2008 blog post from a Sybase blog
2. ↑ Oracle Compliance To Core SQL:2008 from Oracle Corporation

## External links

* Freely downloadable drafts of this standard

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/SQL:2008. Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=SQL:2008&oldid=212820"