Re: How to update node into xml variable?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello

You can't update nodes with XML variable. Instead, you may want to query and
re-compose xml. Something like

select @myxml.query('/*/*[1]'), @newvalue for xml path('root')

<Radovan Dobri? <radovan@xxxxxxxxxxx>> wrote in message
news:%237Su7AFeHHA.208@xxxxxxxxxxxxxxxxxxxxxxx
Hi, I have two variables.

declare @myxml xml,@newvalue xml

set @myxml='
<root>
<node1>
<node11> val1</node11>
<node12> val2</node12>
</node1>
<node2>
<node21></node21>
</node2>
</root>'

Set @newvalue='
<node2>
<node21> val21 </node21>
<node22> val22 </node22>
</node2>'

I wont to update @myxml with @newvalue, so that result in @myvalue would
be:

'
<root>
<node1>
<node11> val1</node11>
<node12> val2</node12>
</node1>
<node2>
<node21> val21 </node21>
<node22> val22 </node22>
</node2>
</root>
'

Thanks in advance

radovan



.

Relevant Pages