Skip to main content

How Do I: Use XML Data in SQL Server?

Rate:  

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.

 

Presented By:  Chris Pels

Downloads

Video: WMV |  MP4 |  WMV (ZIP)