下架所有VB开发的程序的方法

zhgc

delete  from sfc.c_ams_privilege_t where ap_name like 'TR%';
DELETE  FROM SFC.c_ams_privilege_t WHERE AP_NAME  LIKE 'FEEDER%';
DELETE   FROM SFC.c_ams_privilege_t WHERE AP_NAME  LIKE 'BOMT%';
DELETE   FROM SFC.c_ams_privilege_t WHERE AP_NAME  LIKE 'STENCIL%';
DELETE    FROM SFC.c_ams_privilege_t WHERE AP_NAME  LIKE 'MACHINE%';
DELETE   FROM SFC.c_ams_privilege_t WHERE AP_NAME  LIKE 'MANAGE%';
DELETE   FROM SFC.c_ams_privilege_t WHERE AP_NAME  LIKE 'SMT_TOOLS%';
DELETE  FROM SFC.c_ams_privilege_t WHERE AP_NAME  LIKE 'SETUPSHEET%';


SELECT * FROM SFC.C_AMS_AP_T where ap_name like 'TR%'
UNION
SELECT * FROM SFC.C_AMS_AP_T where ap_name like 'FEEDER%'
UNION
SELECT * FROM SFC.C_AMS_AP_T where ap_name like 'BOMT%'
UNION
SELECT * FROM SFC.C_AMS_AP_T where ap_name like 'STENCIL%'
UNION
SELECT * FROM SFC.C_AMS_AP_T where ap_name like 'MACHINE%'
UNION
SELECT * FROM SFC.C_AMS_AP_T where ap_name like 'MANAGE%'
UNION
SELECT * FROM SFC.C_AMS_AP_T where ap_name like 'SMT_TOOLS%'
UNION
SELECT * FROM SFC.C_AMS_AP_T where ap_name like 'SETUPSHEET%'

zhgc

delete FROM SFC.C_AMS_AP_T where ap_name like 'TR%';
DELETE FROM SFC.C_AMS_AP_T where ap_name like 'FEEDER%';
DELETE  FROM SFC.C_AMS_AP_T where ap_name like 'BOMT%';
DELETE  FROM SFC.C_AMS_AP_T where ap_name like 'STENCIL%';
DELETE  FROM SFC.C_AMS_AP_T where ap_name like 'MACHINE%';
DELETE  FROM SFC.C_AMS_AP_T where ap_name like 'MANAGE%';
DELETE  FROM SFC.C_AMS_AP_T where ap_name like 'SMT_TOOLS%';
DELETE  FROM SFC.C_AMS_AP_T where ap_name like 'SETUPSHEET%';

syant