Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jacob Sebastian XML Workshop XVII - Writing a LOOP to process XML elements in TSQL RE: XML Workshop XVII - Writing a LOOP to process XML elements in TSQL

  • October 7, 2009 at 3:35 pm

    #1063116

    I would recommend reading this article that demonstrates how to iterate over the elements of an XML document. http://www.sqlservercentral.com/articles/XML/62290/%5B/url%5D

    The XQuery function "local-name()" can be used to find out the name of an element or attribute.

    .