Module 3: Manipulating XML with Transact-SQL

This module provides students with an understanding of how to insert XML data into SQL Server tables by using the OPENXML statement. After completing this module, students will be able to: Use the OPENXML statement to create a rowset from a single-level Extensible Markup Language (XML) document. Use the OPENXML statement to process rowsets from complex XML documents. Retrieve attributes, elements, or both from an XML document by specifying the appropriate flags parameter with the OPENXML statement. Use XML Path Language (XPath) expressions in rowpattern and colpattern parameters to specify rowset structure....