Home Forums Programming XML Need to select all elements of an XML document from an XML data type column RE: Need to select all elements of an XML document from an XML data type column

  • September 7, 2010 at 3:18 pm

    #1217638

    OK, so how does this differ from what you expect?

    DECLARE @AmendBarsetFlight TABLE (RowID int IDENTITY(1,1), XMLBeforeAction xml, XMLAfterAction xml)

    INSERT INTO @AmendBarsetFlight(XMLBeforeAction, XMLAfterAction)

    VALUES('

    <xml_node>

    <test>XMLBeforeAction</test>

    </xml_node>',

    '

    <xml_node>

    <test>XMLAfterAction</test>

    </xml_node>'

    )

    SELECT XMLBeforeAction,

    XMLAfterAction

    FROM @AmendBarsetFlight

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden