select *
,(select FNAME from T_META_OBJECTTYPE_L where FID = temp.FID and FLOCALEID = 2052)
from
(select FID, FKERNELXML.query('//RadioGroupField') findKey from T_META_OBJECTTYPE) temp
where CONVERT(varchar(max),findKey) <> ''
,(select FNAME from T_META_OBJECTTYPE_L where FID = temp.FID and FLOCALEID = 2052)
from
(select FID, FKERNELXML.query('//RadioGroupField') findKey from T_META_OBJECTTYPE) temp
where CONVERT(varchar(max),findKey) <> ''
这里主要是就是xml查询解析,其他就是数据字典的熟悉