This example shows how to import into a MS SQL table from an XML document, and then query and process the imported data. Before importing, I exported a small piece of data from SQL tables to an XML ...

In this example, nodes('//author') yields a rowset of references to <author> elements for each XML instance. The first and last names of authors are obtained by evaluating value() methods relative to ...