XML Data-type Usage By Other SQL Server 2005 Features

Several of the other features within SQL Server 2005 leverage the XML data-type to pass information around. For example, both Service Broker and triggers transfer data around the server in XML data-type instances. This means that you can easily leverage the power of the XQuery language and other XML data-type methods when using these features….


Static Typing Consequences of the Parent Axis

SQL Server 2005 has an XQuery implementation that provides full support for the parent axis, as defined in the XPath specification. Since our XQuery implementation is statically typed, we also support the static typing of the parent axis, as defined in the XQuery Formal Semantics document. The definition of static typing of the parent axis…

XML Query Test Suite – version 0.6 released

The W3C XQuery Testing Task Force (of which I am a member) has released version 0.6 of the XML Query Test Suite. This is currently available at http://www.w3.org/XML/Query/test-suite/. The test suite consists of XQuery expressions, results and source files that test various different aspects of an XQuery implementation against the latest published drafts of the…

Querying Over Constructed XML Using Sub-queries

There are a number of cases where it would be useful to be able to run XQuery statements over the result of an XQuery expression which constructs new values. Unfortunately, directly querying over constructed XML is not supported in SQL Server 2005, so we need to use a work-around. Since the result of a query()…