22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @t table(i int,x xml)
insert @t select 1,(select '0' as t1,'' as t2 for xml path)
select * from @t
update @t set x.modify('replace value of (/row/t1[1]/text())[1] with "new"')
update @t set x.modify('replace value of (/row/t2[1]/text())[1] with "new1"')
select * from @t