标题: 下架所有VB开发的程序的方法 [打印本页] 作者: zhgc 时间: 2024-3-18 20:23 标题: 下架所有VB开发的程序的方法 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 时间: 2024-3-18 20:24
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%';
