查询插件被哪些单据使用(sql)

--查询插件被哪些单据使用  

--MS SQL Server  

select FID,FKERNELXML  

,(select FNAME  

from T_META_OBJECTTYPE_L  

where FID = T_META_OBJECTTYPE_Temp.FID and FLOCALEID = '2052'  

  ) FNAME  

,Item  

from  

(select FKERNELXML.query('//ClassName') 'Item', * from T_META_OBJECTTYPE)  

T_META_OBJECTTYPE_Temp   

where convert(varchar(max),Item) like '%kingdee%' --插件名(依情况替换此处'kingdee')