This video describes how to load an XML document into SQL Server using OPENROWSET. It also goes over how to query the XML document like a table using OPENXML.
The SQL code used in the video is available at:
http://askadba.blogspot.com/2012/08/h...