Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jacob Sebastian XML Workshop 26 – SELECT * FROM XML RE: XML Workshop 26 – SELECT * FROM XML

  • June 30, 2010 at 3:01 am

    #1186932

    Here is a simple example:

    DECLARE @xml XML

    SELECT @xml = '<employee name="jacob"/>'

    SELECT * FROM XMLTable(@xml)

    WHERE NodeType = 'attribute'

    .