Here is a short 13 minute tutorial I put together on how to use XML within SQL Server. While I made this for the Born to Learn Study Groups, I am sure it will be helpful for others who might be studying for the 70-461 exam.
XML on SQL Tutorial
Related Articles
Intro to Stretch Databases
MCSA: SQL 2016 Development
SQL Saturday – Columbus
John, thank you very much for this tutorial 🙂
@handle is a nice commit in this tutorial !
Thank you for this very useful video, which introduced me first time with XML foundation. I always used to get confused. But now learnt tsql-xml confidence from this video.
HI
Thanks for the video.
I am still curious about the meaning for the @handle.
Why I need that?
The @handle is a variable that hold the XML data in a memory tree after the data has been shredded in the first stored procedure. Then the OpenXML function uses that variable to locate the day to extract it, and then the final stored procedure uses the @handle to locate the data and clean up memory.