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