XQuery Inside SQL Server 2005

Hopefully helpful postings, articles and walkthroughs for people using XQuery inside SQL Server 2005.

XQuery Candidate Recommendation Documents Released

The official candidate recommendation versions of the XQuery specifications have been published by...

Author: mrorke Date: 11/03/2005

Dynamic XQuery Expressions

We have had several requests through our message boards for details on how to execute dynamic XQuery...

Author: mrorke Date: 10/24/2005

XQuery Test Suite - new version 0.7 released

The XQuery Testing Task Force is pleased to announce the publication of version 0.7 of our XQuery...

Author: mrorke Date: 10/18/2005

Static Typing Consequences for the Parent Axis and Attribute Types

I posted a previous blog entry dealing with the static typing consequences of using the parent axis...

Author: mrorke Date: 09/29/2005

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...

Author: mrorke Date: 08/25/2005

Static Typing Consequences of the Parent Axis

SQL Server 2005 has an XQuery implementation that provides full support for the parent axis, as...

Author: mrorke Date: 08/18/2005

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...

Author: mrorke Date: 08/11/2005

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...

Author: mrorke Date: 08/02/2005

Working with XML from Multiple Instances

There are often cases where we need to perform operations based on multiple XML instances. To...

Author: mrorke Date: 07/21/2005

Namespace Nuances

XQuery uses the concept of a namespace, adopted from the XML 1.0 specification. But, due to the...

Author: mrorke Date: 07/11/2005

Performing XSLT Transforms on XML Data Stored in SQL Server 2005

A common task when dealing with XML data is to apply an XSLT style-sheet to the raw XML data in...

Author: mrorke Date: 06/28/2005

Serialization and Concatenating String Values

A common requirement for an XML based application is the ability to do some form of simple string...

Author: mrorke Date: 06/10/2005

Efficient Property Promotion from XML Instances (Part 2)

Last week I covered the basics of property promotion i.e. automatically extracting data from an XML...

Author: mrorke Date: 06/01/2005

Efficient Property Promotion from XML Instances

In many cases, when storing XML data, some of the elements/attributes will be more important for...

Author: mrorke Date: 05/24/2005

Adding a Style-sheet Declaration to your XML Output

A common requirement for formatting XML output from XQuery expressions, is to be able to add a...

Author: mrorke Date: 05/10/2005

MSDN Webcast on using XQuery in SQL Server 2005

Michael Rys (a program manager for XML technologies in SQL Server 2005) recently gave a webcast for...

Author: mrorke Date: 05/06/2005

I have added a new section under my links that points to useful whitepapers dealing with XQuery...

Author: mrorke Date: 05/06/2005

Good Introduction to Using XML in SQL Server 2005

I just reviewed the web cast of a presentation given by one of our program managers here in the SQL...

Author: mrorke Date: 05/06/2005

De-entitizing Special XML Characters

There are several tricky issues around the serialization of special XML characters inside SQL Server...

Author: mrorke Date: 05/05/2005

Running XQuery over multiple XML datatype instances

One of the limitations of using XQuery inside SQL Server 2005 is that you are limited to running...

Author: mrorke Date: 04/19/2005

Using WITH XMLNAMESPACES

My fellow Microsoft Mike (Michael Rys) has just posted an article on his blog highlighting the use...

Author: mrorke Date: 04/19/2005

Analyzing the Static Type of your Query

XQuery inside SQL Server 2005 implements a set of rules that enable us to catch potential problems...

Author: mrorke Date: 04/18/2005

Using SQL datetime and smalldatetime values inside XQuery

I had a request today asking me how to get the current date/time as part of an XQuery expression in...

Author: mrorke Date: 04/13/2005

Welcome!

Welcome to my blog dealing with using XQuery inside of SQL Server 2005. As an introduction to the...

Author: mrorke Date: 04/12/2005