文件名称：海信商海导航SQL修改语句
文件大小：11KB
文件格式：TXT
更新时间：2022-01-17 07:53:22
海信商海导航 SQL修改语句
海信商海导航SQL修改语句/* 删除非储值卡会员*/ delete xvipdb..vip where canstore='0' delete xvipdb..viptopos where canstore='0' /* 修改上次结帐日期*/ update SysDB..Syscfg set ItemValue='2007-04-10 1' where ItemName='OVERSTATUS' update VipDB..Syscfg set ItemValue='2007-04-10 1' where ItemName='OVERSTATUS' use Xvipdb /*将储值卡会员变成非储值卡会员*/ update vip set CanStore='0' where canstore='1' and viptype='2' update vip set CanStore='0' where canstore='1' and viptype='2' /*将非储值卡会员变成储值卡会员*/ update vip set CanStore='1' where canstore='0' and viptype='2' .......................................................................