sql server xml二

declare @xml xml
select @xml='<class>
<student id="1">
<name>chinajiabing </name>
<sex>男</sex>
<age>20</age>
</student>
<student id="2">
<name>jiabing </name>
<sex>男</sex>
<age>23</age>
</student>
</class>'
--1.query 获得第二名同学的年龄元素
select @xml.query('class/student[@id=2]/age[1]')
--2.value 获得第二名同学的年龄只含内容
select @xml.value('(/class/student[@id=2]/age)[1]','nvarchar(max)')
--3.查找id等于
select   @xml.exist('/class/student[@id="2"]')
--4.修改
set @xml.modify('replace value of(class/student[@id="1"]/name/text())[1] with "jia"')
set @xml.modify('replace value of(clsss/student[@id="1"]/name/text())[1] with "jix"')

set @xml.modify('replace value of(class/student[@id="1"]/name/text())[1] with "jiabing"')

--5.删除
set @xml.modify('delete class/student[@id=2]')

select  @xml