"tsql split xml nodes" Code Answer

12

Try something like this:

SELECT 
    ID, 
    XmlChanges.query('.')
FROM
    @test
CROSS APPLY
    Changes.nodes('/*') AS Nodes(XmlChanges)

The resulting output would be:

ID  (No column name)
1   <insert pk="1" />
1   <insert pk="2" />
1   <delete pk="1" />
1   <delete pk="2" />
2   <insert pk="3" />
By Xavier Priour on May 5 2022

Answers related to “tsql split xml nodes”

Only authorized users can answer the Search term. Please sign in first, or register a free account.