5 Comments on "XML on SQL Tutorial"

  1. John, thank you very much for this tutorial 🙂

  2. @handle is a nice commit in this tutorial !

  3. 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.

  4. HI
    Thanks for the video.
    I am still curious about the meaning for the @handle.
    Why I need that?

    • John Deardurff | November 12, 2016 at 8:35 am | Reply

      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.

Leave a comment

Your email address will not be published.


This site uses Akismet to reduce spam. Learn how your comment data is processed.