declare @bb xml
set @bb = '<a><b><c></c><d></d><e></e><f></f><g></g></b></a>'
set @bb = ''
declare @cc int
--注:exist函数区分大小写
set @cc = @bb.exist('/a/b/c')
select @cc as cc
declare @bb xml
set @bb = '<a><b><c></c><d></d><e></e><f></f><g></g></b></a>'
set @bb = ''
declare @cc int
--注:exist函数区分大小写
set @cc = @bb.exist('/a/b/c')
select @cc as cc