思迅商业之星V6中批量删除会员号的处理方法,运行“查询分析器”,执行下面的语句就可以了!
use hbposv6
alter table t_rm_vip_info disable trigger all
delete from t_rm_vip_info where card_id between '1001' and '1010'
alter table t_rm_vip_info enable trigger all
--可以指定会员卡号段删除
use hbposv6
alter table t_rm_vip_info disable trigger all
truncate table t_rm_vip_info
alter table t_rm_vip_info enable trigger all
delete from t_rm_vip_consume
--这个是清空会员卡表