SQL:2006: Difference between revisions

Revision as of 12:26, 6 May 2012

Latest revision as of 10:00, 1 June 2025

(25 intermediate revisions by 21 users not shown)

Line 1:

{{Short description|2006 edition of the SQL standard}}

<!-- ==Summary== -->

{{SQL language revisions}}

'''SQL:2006''' or '''[[ISO 9075|ISO/IEC 9075:2006]] standard'''

{{Use dmy dates|date=January 2025}}

is the fifth revision of the [[International Organization for Standardization|ISO]] standard for the [[SQL]] [[database]] [[query language]].

{{More citations needed|date=June 2025}}

is'''SQL:2006''' theor '''[[ISO 9075|ISO/IEC 9075:2006]] standard''' is fiftha revision part 14 (ISO/IEC 9075-14:2006) of the [[International Organization for Standardization|ISO]] standard for the [[SQL]] [[database]] [[query language]]. It is not a revision of the complete SQL standard.

==New features==

The main changes about [[SQL:2003]] was at the Part 14 of the standard.

The standard includes extensions to part 14 (ISO/IEC 9075-14:2006). This part defines ways in which SQL can be used in conjunction with [[XML]]. It defines ways of 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. In addition, it enables applications to integrate into their SQL code the use of [[XQuery]], the XML Query Language published by the [[World Wide Web Consortium]] ([[W3C]]), to concurrently access ordinary SQL-data and XML documents.<ref>{{Cite book |last=Wagner |first=Michael |title=SQL/XML: 2006 - Evaluierung der Standardkonformität ausgewählter Datenbanksysteme |date=2010 |publisher=Diplomica Verlag |isbn=978-3-8366-9609-8 |___location=Hamburg |pages=100}}</ref>

==See Part 14also==

* [[SQL]]

ISO/IEC 9075-14:2006 defines ways in which SQL can be used in conjunction with XML. It defines ways of 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. In addition, it enables applications to integrate into their SQL code the use of [[XQuery]], the XML Query Language published by the World Wide Web Consortium ([[W3C]]), to concurrently access ordinary SQL-data and XML documents.

* [[SQL:2003]]

== See also ==

* [[SQL:2008]] content is similar to SQL:2006.

==References==

{{reflist|1}}

==External links==

{{Wikibooks|Structured Query Language}}

{{SQL}}

[[Category:ISO standards]]

[[Category:SQL|*]]