【文件属性】:
文件名称:海信商海导航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'
.......................................................................