One of the limitations of using XQuery inside SQL Server 2005 is that you are limited to running your expressions over a single XML data type instance. It is usually possible to insert your XML into the database so that this is not a problem (e.g. placing...

My fellow Microsoft Mike (Michael Rys) has just posted an article on his blog highlighting the use of the new T-SQL with xmlnamespaces syntax. This syntax allows you to simplfy your XQuery statements by defining namespaces in the T-SQL world and having...

XQuery inside SQL Server 2005 implements a set of rules that enable us to catch potential problems with the user query at compile time, based on static analysis of the query. The complete rules for static analysis of XQuery expressions are detailed in...

Using SQL datetime and smalldatetime values inside XQuery...

Welcome to my blog dealing with using XQuery inside of SQL Server 2005. As an introduction to the kind of information I intend to populate this blog with, I have started off writing an atricle on how to take the examples from the XQuery Use Case documents...