SQL:2006: Difference between revisions

Revision as of 14:21, 26 August 2015

Latest revision as of 10:00, 1 June 2025

(16 intermediate revisions by 15 users not shown)

Line 1:

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

<!-- ==Summary== -->{{unref|date=June 2012}}

{{SQL language revisions}}

'''SQL:2006''' or '''[[ISO 9075|ISO/IEC 9075:2006]] standard''' is the fifth revision of the [[International Organization for Standardization|ISO]] standard for the [[SQL]] [[database]] [[query language]].

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

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

'''SQL:2006''' or '''[[ISO 9075|ISO/IEC 9075:2006]] standard''' is the 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 from [[SQL:2003]] were in 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>

==Part 14==

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.

==See also==

* [[SQL]]

* [[SQL:2003]]

* [[b:Structured Query Language|Wikibook SQL]]

* [[SQL:2008]]

==References==

{{reflist|1}}

==External links==

* [[b:{{Wikibooks|Structured Query Language|Wikibook SQL]]}}

{{SQL}}

[[Category:ISO standards]]

[[Category:SQL| *]]