Hi,
In sql-server we have modify,exist and delete functions to change the xml data. Below is the example of replacing the xml value when it is having some specified value.
Example: I want to change the Node A value only when it is having 1 as a value
declare @tbl table(col xml)
declare @sql xml ='<SomeNode><A>1</A><B>1</B></SomeNode><SomeNode><A /><B /></SomeNode><SomeNode><A /><B /></SomeNode>'
insert into @tbl
select @sql
select * from @tbl
update @tbl
set col.modify('replace value of (/SomeNode/A[. = "1"]/text())[1]
with ""')
where col.exist('/SomeNode[A = "1"]') = 1 and
col.exist('/SomeNode[A = "1"]') = 1
select * from @tbl
Thx,
RS
11/12/13
