SQLServer查询XML节点

用Xpath对XML进行查询

1.query查询，查询结果是节点

select Content.query('(/WorkflowDefine/Define/WorkflowBuilder/Activities/Activity[Participant/Role="总经理"])') as activity
from tablename

2.value查询，查询结果是值

select Content.value('(/WorkflowDefine/Define/WorkflowBuilder/Activities/Activity/Participant[Role="总经理"])[1]','nvarchar(max)') as activity
from tablename