/取节点PackageConditon和BrandConditon里的字段值
Conditions--------为根元素
/PackageCondition,BrandCondtion-----为节点
/auto_match----为字段属性
select
auto_match.value('(/Conditions/PackageCondition)[1]','nvarchar(max)') a,
auto_match.value('(/Conditions/BrandCondition)[1]','nvarchar(max)') b ,
article_group_id
from CMS_articlegroup
where auto_match is not null