SELECT * FROM XML

This post shows how to run a SELECT * kind of query on an XML document to see the elements, attributes, values and the XPath Expression of each element and attribute in the document.