毒药存储过程

fsf1982 · 发表于 2024-5-1 17:26:38

CREATE PROCEDURE RMS_INITBONUS2
@GameID varchar(14)
AS
set nocount on
begin transaction
declare @BonusLevel int
declare @Bonus int
select @BonusLevel = Lvl from tblGameID1 where GameID = @GameID
IF @BonusLevel>1000
select @BonusLevel=1000
SET @Bonus = @BonusLevel * 2 + @BonusLevel / 100
update tblGameID1 set Strength = 10, Spirit = 10, Dexterity = 10, Power = 10, Bonus = @Bonus where GameID = @GameID
update tblGameID1 set Bonus2 = 0 where GameID = @GameID AND SBonus > STotalBonus
update tblGameID1 set Bonus2 = STotalBonus - SBonus where GameID = @GameID AND STotalBonus >= SBonus
commit transaction
GO

复制代码

liangxw520 · 发表于 2024-5-1 20:42:05

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

Chinese.Doll · 发表于 2024-5-4 01:33:25

！上向天天，习学好好

		自动登录	找回密码
密码			立即注册

[脚本] 毒药存储过程