会员作废

wbv123

select * into d_memcard_reg_zf_bak1227 from u_memcard_reg where ISNULL(saleamount,0)<=0 and cardstatus=1

–update u_memcard_reg set cardstatus=2 where ISNULL(saleamount,0)<=0 and cardstatus=1

select * from u_memcard_reg where ISNULL(saleamount,0)<=0 and cardstatus=1

会员应收金额小于等于0的全部作废。