How Do I: Use XML Data in SQL Server?
About This Video
In this video Chris Pels will show how to pass XML to a stored procedure as a method of passing a variable number of parameters to the stored procedure. A sample XML structure is created then passed to a stored procedure and the values extracted using the OPENXML statement. The data is extracted into a table variable as a way to store the XML data in a tabular structure that can be reused. Finally, the concept of column mapping between the XML data and the tabular structure is covered.