Use XML Data in SQL Server
How Do I: Use XML Data in SQL Server?
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
Tags:
DownloadsVideo: WMV | MP4 | WMV (ZIP) | PSP | 3GP | iPod | ZuneAudio: AAC | WMA | MP2 | MP3 | MP4 Code: SQL | |
