SQL:2008: Difference between revisions

Revision as of 04:19, 1 March 2011

Revision as of 10:20, 6 April 2011

Line 7:

The SQL:2008 standard is split into several parts, covering the Framework, the Foundation, the [[SQL/CLI|Call-Level Interface]], [[SQL/PSM|Persistent Stored Modules]], [[SQL/MED|Management of External Data]], [[SQL/OLB|Object Language Bindings]], [[SQL/Schemata|Information and Definition Schemas]], [[SQL/JRT|Routines and Types]] Using [[Java (programming language)|Java]], and various "Related Specifications."

Additions to the Foundation include

Additions to the Foundation include enhanced [[Merge (SQL)|MERGE]] and DIAGNOSTIC statements, the [[Truncate (SQL)|TRUNCATE TABLE]] statement, comma-separated WHEN clauses in a CASE expression, 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"/>

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

*the [[Truncate (SQL)|TRUNCATE TABLE]] statement,

*comma-separated WHEN clauses in a CASE expression,

*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"/>

The Related Specifications for XML defines ways in which SQL can be used in conjunction with [[XML]], including importing and storing XML data in an SQL database, manipulating it within the database and publishing both XML and conventional SQL-data in XML form.<ref name="9075-14:2008">International Organization for Standardization: "ISO/IEC 9075-14:2008"</ref>