How we can Modify XMl Data in SQL Server 2005?

 Posted by Lakhangarg on 9/16/2009 | Category: Sql Server Interview questions | Views: 5242

Using modify method we cam modify the data in XML.

set @value = 'val3'
set @xml.modify('replace value of (/root/item/@value)[1] with sql:variable("@value")')
select @xml

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response