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...
Date: 11/03/2005
Dynamic XQuery Expressions
We have had several requests through our message boards for details on how to execute dynamic XQuery...
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...
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...
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...
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...
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...
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...
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...
Date: 07/21/2005
Namespace Nuances
XQuery uses the concept of a namespace, adopted from the XML 1.0 specification. But, due to the...
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...
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...
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...
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...
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...
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...
Date: 05/06/2005
New links section for whitepapers
I have added a new section under my links that points to useful whitepapers dealing with XQuery...
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...
Date: 05/06/2005
De-entitizing Special XML Characters
There are several tricky issues around the serialization of special XML characters inside SQL Server...
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...
Date: 04/19/2005
Using WITH XMLNAMESPACES
My fellow Microsoft Mike (Michael Rys) has just posted an article on his blog highlighting the use...
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...
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...
Date: 04/13/2005
Welcome!
Welcome to my blog dealing with using XQuery inside of SQL Server 2005. As an introduction to the...
Date: 04/12/2005