<Books>
<book>
<name>sql server 2008</name>
</book>
<book>
<name>mysql</name>
</book>
</Books>使用XQuery将<book><name>mysql</name></book>节点删除结果:
<Books>
<book>
<name>sql server 2008</name>
</book>
</Books
<book>
<name>sql server 2008</name>
</book>
<book>
<name>mysql</name>
</book>
</Books>使用XQuery将<book><name>mysql</name></book>节点删除结果:
<Books>
<book>
<name>sql server 2008</name>
</book>
</Books
DECLARE @myDoc xml
SET @myDoc = '<Books>
<book>
<name>sql server 2008</name>
</book>
<book>
<name>mysql</name>
</book>
</Books>'
SET @myDoc.modify('
delete /Books/book[name=''mysql'']
')print convert(varchar(max), @myDoc)
---------------------------
<Books><book><name>sql server 2008</name></book></Books>
delete //book[name=''mysql'']
')