We have an external file that we receive periodically that needs to be shredded into tables into SQL Server. In this example, we have a bookstore. We order from book manufacturers and they send us an XML file listing the books we ordered. To keep things simple, our file in […]

SQL Server XML Shredding Part 5

XPath Axes This post is based on a tutorial at w3schools.com. An axis defines a node-set relative to the current node. For example, self selects the current node, and child selects all children of the current node. The following XML document will be used in the following examples. AxisName Result […]

XML XPath Axes and Operators