DECLARE @parameters XML SET @parameters='<Parameter><id>3</id><key>ip</key><val>10.97.151.46</val></Parameter> <Parameter><id>6</id><key>pno</key><val>107</val></Parameter>' SELECT RecId.ID.value('.','VARCHAR(20)'), RecKey.KY.value('.','VARCHAR(20)'), RecVal.VL.value('.','VARCHAR(20)') FROM @parameters.nodes('/Parameter/id') as RecId(ID), @parameters.nodes('/Parameter/key') as RecKey(KY), @parameters.nodes('/Parameter/val') as RecVal(VL)
3 ip 10.97.151.46 3 pno 10.97.151.46 3 ip 107 3 pno 107 6 ip 10.97.151.46 6 pno 10.97.151.46 6 ip 107 6 pno 107
3 ip 10.97.151.46 6 pno 107
SELECT RecId.ID.query('key').value('.','VARCHAR(20)'), RecId.ID.query('val').value('.','VARCHAR(20)') FROM @parameters.nodes('/Parameter') as RecId(ID)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)