SQL XML Modify

Insert / Delete inside XML


Declare @xml xml
SET @xml = 'Test/Test'

set @xml.modify('insert attribute txt {/Report/text()} into (/Report/Folder)[1]')
set @xml.modify('delete /Report/text()')
select @xml