Archive for May, 2012

How To : Load XML data into multiple tables

May 10, 2012 12 comments

Here’s a short article presenting a common technique to load data from a single XML document into different tables, using a single INSERT statement.
A typical use case is an XML structure describing a master-detail relationship, such as the classic invoice or purchase order document (header + line items).
Read more…

Categories: HowTo, Miscellaneous Tags: ,