业务对象“物料清单:ENG_BOM”超过软件授权200条记录的控制,则不能打开该业务对象所在子系统下的所有加密单据!原创
10人赞赏了该文章
592次浏览
编辑于2023年11月03日 15:21:54
在测试数据库执行如下脚本
select * from T_HR_EMPINFO DELETE FROM T_HR_EMPINFO WHERE FID NOT IN (SELECT t1.FID FROM (SELECT top 100 FID FROM T_HR_EMPINFO ORDER BY FID ) AS t1); select * from T_BD_MATERIAL DELETE FROM T_BD_MATERIAL WHERE FMATERIALID NOT IN (SELECT t1.FMATERIALID FROM (SELECT top 100 FMATERIALID FROM T_BD_MATERIAL ORDER BY FMATERIALID ) AS t1); select * from t_BD_Supplier DELETE FROM t_BD_Supplier WHERE FSUPPLIERID NOT IN (SELECT t1.FSUPPLIERID FROM (SELECT top 100 FSUPPLIERID FROM t_BD_Supplier ORDER BY FSUPPLIERID ) AS t1); select * from T_BD_CUSTOMER DELETE FROM T_BD_CUSTOMER WHERE FCUSTID NOT IN (SELECT t1.FCUSTID FROM (SELECT top 100 FCUSTID FROM T_BD_CUSTOMER ORDER BY FCUSTID ) AS t1); select * from T_ENG_BOM DELETE FROM T_ENG_BOM WHERE FID NOT IN (SELECT t1.FID FROM (SELECT top 100 FID FROM T_ENG_BOM ORDER BY FID ) AS t1);
推荐阅读