declare @xml xml
set @xml='<root >
<item ID="cc" Name="bb">
<items ID="dd" Name="dd"></items>
<items ID="584" Name="dd"></items>
<items />
</item>
<item ID="rr" Name="58">
<items ID="drd" Name="69"></items>
<items />
<items ID="14e" Name="dd"></items>
</item>
<item ID="478e" Name="58">
<items ID="684" Name="987"></items>
<items />
<items ID="5847" Name="dd"></items>
<items ID="987" Name="dd"></items>
<items ID="2140" Name="dd"></items>
</item>
</root>'
--------多个属性的添加============
set @xml.modify('insert( attribute ID{"All"},attribute Name{"所有"}) into (/root)[1]')--添加ID與Name屬性
--删除items节点属性ID为空的
set @xml.modify('delete //items[empty(@ID)]')
select @xml