网站首页 一条龙套餐 游戏版本 网站模版 广告代理 主机租用 短信平台 技术教程
 
奇迹一条龙军衔SQL语句
作者:佚名 来源:本站原创 点击数: 更新时间:2016/4/9 18:09:05

1.执行如下数据库语句

CREATE PROCEDURE UP_MEMB_INFO_Update_JF
@memb___id varchar(10),
@jf int
AS
        UPDATE [MEMB_INFO] SET [jf] = @jf + [jf]
        WHERE memb___id=@memb___id
GO

2.执行如下数据库语句

CREATE PROCEDURE DOWN_MEMB_INFO_Update_JF
@memb___id varchar(10),
@jf int
AS
        UPDATE [MEMB_INFO] SET [jf] = [jf] - @jf
        WHERE memb___id=@memb___id
GO


军衔任务SQL语句:执行如下数据库语句

use MuOnline
go
if not exists (select 1 from syscolumns where name = 'JxDw' and id = object_id('Character'))
 alter table Character
 add JxDw int DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'JxPoint' and id = object_id('Character'))
 alter table Character
 add JxPoint int DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'CquestMonsterCount1' and id = object_id('Character'))
 alter table Character
 add CquestMonsterCount1 int DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'CquestMonsterCount2' and id = object_id('Character'))
 alter table Character
 add CquestMonsterCount2 int DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'CquestMonsterCount3' and id = object_id('Character'))
 alter table Character
 add CquestMonsterCount3 int DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'CquestPkCount' and id = object_id('Character'))
 alter table Character
 add CquestPkCount int DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'CquestST' and id = object_id('Character'))
 alter table Character
 add CquestST int DEFAULT (0)
go


Update Character set JxPoint=0 where JxPoint is null
Update Character set JxDw=0 where JxDw is null
Update Character set CquestPkCount=0 where CquestPkCount is null
Update Character set CquestST=0 where CquestST is null
Update Character set CquestMonsterCount1=0 where CquestMonsterCount1 is null
Update Character set CquestMonsterCount2=0 where CquestMonsterCount2 is null
Update Character set CquestMonsterCount3=0 where CquestMonsterCount3 is null

 
 
Copyright 2004-2008 HttP://www.8828mu.comAll Rights Reserved 版权所有:奇迹数据专业打造,奇迹一条龙,奇迹sf一条龙,奇迹开区一条龙,奇迹版本,www.8828mu.comHttP://www.8828mu.com
☆ 建议使用:1024×768 分辨率 Windows2000 Internet Explorer V5.0 or higher ☆