sql常用语句(三)

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

sql常用语句(三)

--转换规则 select * from T_META_CONVERTRULE where FID like '%rem_%'select * from T_META_CONVERTRULE_L --反写规则 select * from T_BF_WRITEBACKRULE where fsourceformid like '%SFC_%' and ftargetformid like '%SFC_%' --参数 select * from t_bas_sysparameter --枚举值 select * from T_META_FORMENUM ejoin T_META_FORMENUM_L el on el.FID=e.FIDwhere FNAME like '%生产线领料单%' --单据类型 select * from T_BAS_BILLTYPE where FBILLFORMID like '%REM_INSTOCK%' --菜单操作对应类名 select * from T_MDL_FORMOPERATIONTYPE --操作里面的服务 select * from T_MDL_FORMBUSINESS_L where FDESC like '%更新即时库存%' select * from T_MDL_FORMBUSINESS where FACTIONID=45 --保存界面布局 select * from T_BAS_FormParameterwhere FPARAOBJID like '%SFC_OperationPlanning%'--用户select * from T_SEC_USER

sql常用语句(三)

--转换规则select * from T_META_CONVERTRULE where FID like '%rem_%'select * from T_META_CONVERTRULE_L--反写规则select *...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息