How to update a particular XML node without attribute.
955609Aug 14 2012 — edited Aug 14 2012I am facing some issue while updating a XML node ('< `a><`b>NULL< //b><//a>'). In my XML b also exists with an attribute value too.
'< `a >
<` b>NULL< //b>
<`b Attr="attr_val">Raj< //b>
< //a>'
So while using below updatexml, both the nodes are getting updated.
UPDATE xml_temp
SET FPML=UPDATEXML(FPML,'/a/b/text()','some_val');
Can somebpdy please help to update node b of without attribute.
Thanks in advance.
P.S.: I have made XML tags invalid purposefully. Don't mind to that :).
Edited by: 952606 on Aug 13, 2012 10:35 PM
Edited by: 952606 on Aug 13, 2012 10:37 PM