再谈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]')