Browse by Tags

Grabbing Node Names and Values Pt. 2

As a follow-up to my last post on grabbing node names and values , I was asked about grabbing URIs from more complex XML documents. The following query is the result of that discussion: DECLARE @x xml ; SET @x = N '<?xml version = "1.0"?> <root xmlns:n = "uri:components:name"...

Posted to Pro SQL Server XML (Weblog) by Mike C on 03-08-2008
Unmatched Nodes in XQuery

In a previous post I talked about performing "inner joins" in XQuery. The basic idea is that the inner join is simply a special case of a Cartesian product, or "cross join". In this post I'm going to briefly look at another common SQL-style join condition that can be duplicated...

Posted to Pro SQL Server XML (Weblog) by Mike C on 02-24-2008
Retrieving Recursive Hierarchical Data

Part of the promise of XML is that it makes modeling hierarchical data relatively painless. The hierarchical structure of XML automatically provides context to your data. Consider the following simple example: < General name = " Grant " > < Colonel name = " Sanders " >...

Posted to Pro SQL Server XML (Weblog) by Mike C on 02-15-2008

Page 1 of 1 (3 items)

SQLServerCentral.com