首页 › 综合教程 › 红月属性封顶代码

fsf1982 发表于 2024-5-1 17:28:40

红月属性封顶代码

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
select @STotalBonus=STotalBonus from tblGameID1 where GameID = @GameID
if @STotalBonus<30000(封顶数值)
begin
update tblGameID1 set SBonus = SBonus + 1, STotalBonus = STotalBonus + 1 where GameID = @GameID
set @IncreaseBonusError = @@ERROR
end

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

liangxw520 发表于 2024-5-1 20:40:22

感谢楼主的分享!很实用，学到很多东西！！楼主加油多分享点使用的东西哦！！加油加油！！

beinimaruhao 发表于 2024-5-1 23:23:58

学习到了，谢谢楼主，摸摸大:lol

云翳小岚 发表于 2024-5-10 09:52:22

感谢分享 学习了学习了

Chinese.Doll 发表于 2024-7-9 07:31:49

！上向天天，习学好好

查看完整版本: 红月属性封顶代码