再谈xml
修改数据 xml类型数据
xml.modify(' replace value of (/Root/Location/step[1]/text())[1] with "modify data "')
xml.modify(' replace value of (/Root/Location/step/@values] with "modify values"')
删除数据 xml类型数据
UPDATE T
SET x.modify('delete /Root/ProductDescription/Features/*[1]')
xml.modify(' replace value of (/Root/Location/step[1]/text())[1] with "modify data "')
xml.modify(' replace value of (/Root/Location/step/@values] with "modify values"')
删除数据 xml类型数据
UPDATE T
SET x.modify('delete /Root/ProductDescription/Features/*[1]')
