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
Past SQL Posts
- December 4, 2018 | New Writing SQL Video Series
- December 13, 2016 | Restore vs Recovery
- April 2, 2016 | XML on SQL Tutorial
- December 5, 2015 | What are Locks?
- December 2, 2015 | Transactions and Errors
- December 1, 2015 | What are Transactions?
- November 30, 2015 | Working with Batches
- November 27, 2015 | Working with Schemas
- November 16, 2015 | SQL Four Part Names
- October 27, 2015 | SQL Query Processing
- August 24, 2015 | SQL COALESCE Function
- July 28, 2015 | The Output Clause
- July 23, 2015 | Delete vs Truncate vs Drop
- July 21, 2015 | IDENTITY Columns
- July 18, 2015 | Using the INSERT statement
- July 14, 2015 | Data Manipulation Language (DML)
- June 15, 2015 | SQL Join Types
- June 14, 2015 | DML Triggers
- June 10, 2015 | SQL Table Constraints
- June 7, 2015 | Working with SQL Tables
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.