年结删除多余数据测试使用.docVIP

年结删除多余数据测试使用.txt如果有来生，要做一棵树，站成永恒，没有悲伤的姿势。一半在土里安详，一半在风里飞扬，一半洒落阴凉，一半沐浴阳光，非常沉默非常骄傲，从不依靠从不寻找。/* select * from ctl_tbl where tname like MPS% SELECT COUNT(*) FROM mps_mfg_det */ 可能要比 LIKE 的效率稍高 ------------------------ SELECT * FROM ordermst ORDER BY SYSNO DELETE FROM ordermst WHERE SYSNO NOT LIKE P101% DELETE FROM orderdet WHERE SYSNO NOT LIKE P101% DELETE FROM sendmst WHERE SYSNO NOT LIKE P101% DELETE FROM senddet WHERE SYSNO NOT LIKE P101% SELECT SYSNO FROM sbackdet ORDER BY SYSNO DELETE FROM sbackdet WHERE SYSNO LIKE S1010% DELETE FROM sbackmst WHERE SYSNOS1011010001 SELECT SYSNO FROM sbackmst WHERE SYSNOS0601030002 ORDER BY SYSNO DELETE FROM sbillmst WHERE SYSNOQ1011010001 DELETE FROM sbillmst WHERE SYSNO LIKE S0% DELETE FROM sbillmst WHERE SYSNO LIKE S100% DELETE FROM sbillmst WHERE SYSNO LIKE S1010% DELETE FROM reqdet WHERE sreqno11011010001 SELECT * FROM reqdet --WHERE sreqno11011010001 ORDER BY sreqno DELETE FROM reqmst WHERE sreqno11011010001 SELECT * FROM purdec WHERE spurno G1011010001 ORDER BY spurno DELETE FROM purdec WHERE spurno G1011010001 --------------------------------------- SELECT * FROM purmst WHERE spurno G1011010001 ORDER BY spurno DELETE FROM purmst WHERE spurno G1011010001 SELECT * FROM purmst --WHERE spurno G1011010001 ORDER BY spurno --------------------------------------- DELETE FROM rtndec WHERE srtnno J1011010001 SELECT * FROM rtndec --WHERE srtnno J1011010001 ORDER BY srtnno DESC --------------------------------------- SELECT * FROM rtnmst --WHERE srtnno J1011010001 ORDER BY srtnno DESC DELETE FROM rtnmst WHERE srtnno J1011010001 --------------------------------------- SELECT * FROM recdet --WHERE srecno 21011010001 ORDER BY srecno DESC DELETE FROM recdet WHERE srecno 21011010001 --------------------------------------- SELECT * FROM recmst --WHERE srecno 21011010001 ORDER BY srecno DESC DELETE FROM recmst WHERE srecno 21011010001 -------------------------------------- SELECT * FROM rcvdet 只有15行数据 ？？？？？？ drop table rcvdet OK select * in