Thomas Müller: Passing XQuery sequence sections
Thomas talks about the roadmap of SQL with regard to XML support. (Slides, in German)
The current version of SQL (SQL 2003) has an XML datatype and some functions for converting between XML bits and relational data.
SQL 2007 will adapt the XQuery data model for the XML datatype and will allow embedding of XQueries into SQL (!).
SELECT C.Name, XMLQuery('$e//...' PASSING C.Procurement AS "e")
FROM Customer C
WHERE C.CustId > 2105
[The meat of the talk was over my head.]
Ah…excuse me…there is no SQL 2003…