k3 cloud中根据表明查找业务对象

k3 cloud中根据表明查找业务对象(表名称:PAEZ_SignOutRege)

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 '%PAEZ_SignOutRege%'

原文地址:https://www.cnblogs.com/woshinige/p/13915487.html