Tsql Split Xml Nodes

How can I query a table that looks like this: DECLARE @test as table ( [Id] int, [Changes] XML ) insert into @test VALUES (1,'

Solution 1:

Try something like this:

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

The resulting output would be:

ID  (Nocolumn name)
1<insert pk="1" />1<insert pk="2" />1<delete pk="1" />1<delete pk="2" />2<insert pk="3" />

Share