select * from dbo.pos_t_vip_info

ALTER TABLE pos_t_vip_info DISABLE TRIGGER ALL --关闭触发器 
update dbo.pos_t_vip_info set total_integral=vip_integral,vip_cons_amount=vip_integral,cons_count=0,card_amount  =card_balance ,card_make_flag='N',card_send_flag ='N',day_limitedpay =0.0000,vip_sex ='女',mail_flag =0,cons_point =0.0000 --where total_integral<>vip_integral --,vip_cons_amount=vip_integral
ALTER TABLE pos_t_vip_info ENABLE TRIGGER ALL  --打开触发器
--vip_cons_amount='0',vip_integral='0',total_integral='0'