CREATE PROCEDURE RMS_INCREASEBONUSQUESTCOUNT
@GameID varchar(14)
AS

set nocount on

declare @IncreaseBonusError int, @InsertLogError int, @STotalBonus int
set @IncreaseBonusError = 1
set @InsertLogError = 1
set @STotalBonus = 0

begin transaction

update tblGameID1 set SBonus = SBonus + 1, STotalBonus = STotalBonus + 1 where GameID = @GameID
set @IncreaseBonusError = @@ERROR

select @STotalBonus = STotalBonus from tblGameID1 where GameID = @GameID

insert tblBonus2Log1 (GameID, STotalBonus, Kind) values (@GameID, @STotalBonus, 1)
set @InsertLogError = @@ERROR

if @IncreaseBonusError = 0 AND @InsertLogError = 0
begin
commit transaction
end
else
begin
rollback transaction
end
GO

能不能 帮 把以上 SBonus = SBonus + 1, STotalBonus = STotalBonus + 1
设置成 当 STOTALBONUS < 100 SBonus <100 的时候
才可以 SBonus = SBonus + 1, STotalBonus = STotalBonus + 1

update tblGameID1 set SBonus = SBonus + 1, STotalBonus = STotalBonus + 1
where (GameID = @GameID )and ( STOTALBONUS < 100)and(SBonus <100)

desgin by 卜酷塔

[此贴子已经被作者于2005-12-15 11:26:12编辑过]