SQL:2008

Uses your system voice; voice and rate in settings.

Snapshot

≈ 1 min read

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

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. The standard consists of 9 parts which are described in detail in SQL. The next iteration is SQL:2011

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. The standard consists of 9 parts which are described in detail in SQL. The next iteration is SQL:2011 ==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. ==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. ==See also== ==References== ==External links== Freely downloadable drafts of this standard

Text derived from https://en.wikipedia.org/w/index.php?oldid=1323280643 under CC BY-SA 4.0; modifications have been made.