2008
From Handwiki 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
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.0 1.1 SQL:2008 now an approved ISO International Standard , a July 29th, 2008 blog post from a Sybase blog
- ↑ Oracle Compliance To Core SQL:2008 from Oracle Corporation
External links
 |  |
Categories: [SQL] [Declarative programming languages] [Query languages]
↧ Download as ZWI file | Last modified: 03/11/2024 09:30:38 | 13 views
☰ Source: https://handwiki.org/wiki/SQL:2008 | License: CC BY-SA 3.0
✘
ZWI is not signed. [what is this?]
ZWI viewer
by the 
KSF
KSF