您好:IC卡请做芯片清除处理,磁卡可用以下语句删除。先备份数据库。
use issrestv6
go
delete from dbo.t_m_curamount where vch_memberno = '会员编号'
delete from dbo.t_m_deposit where vch_memberno = '会员编号'
delete from dbo.t_m_member where vch_memberno = '会员编号'
delete from dbo.t_m_member_log where vch_memberno = '会员编号'
delete from dbo.t_m_pay where vch_memberno = '会员编号'
delete from dbo.t_m_point where vch_memberno = '会员编号'