1使用表中列名值替换xml节点值
UPDATE
TableName
SET XmlControlAttribute.modify('replace value of (/ControlAttributeValue/ControlAttributes/BaseControlAttributeEx[@ControlAttributeId="21014561879756800"]/DefaultValue/text())[1] with sql:column("字段名") ')
2使用固定值替换xml节点值
UPDATE
TableName
SET XmlControlAttribute.modify('replace value of (/ControlAttributeValue/ControlAttributes/BaseControlAttributeEx[@ControlAttributeId="21014561879756800"]/DefaultValue/text())[1] with "固定值"')
3使用节点替换节点值 没成功
借助的1、2使用中间值做的处理
4查询节点值
select top 1000 Id,DataFlag,
XmlControlAttribute.value('(/ControlAttributeValue/ControlAttributes/BaseControlAttributeEx[@ControlAttributeId="20475463468191744"]/DefaultValue)[1]','varchar(100)')
from BillEntityDesignItems