--- 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'