星空知道表查询业务对象原创
2人赞赏了该文章
12次浏览
编辑于2024年09月30日 16:37:12
select FID,(select FNAME from T_META_OBJECTTYPE_L where FID = T_META_OBJECTTYPE_Temp.FID and FLOCALEID = 2052) FNAME,FKERNELXML,(select FNAME from T_META_OBJECTTYPE_L where FID = T_META_OBJECTTYPE_Temp.FID and FLOCALEID = '2052') FNAME,Item from(select FKERNELXML.query('//TableName') 'Item', * from T_META_OBJECTTYPE)T_META_OBJECTTYPE_Temp where convert(varchar(max),Item) like '%T_BOS_COMPOSITEPACKAGE%'
推荐阅读