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-7-13 11:11:21

！上向天天，习学好好

QWERASD 发表于 2024-7-18 20:06:24

学习到了,继续发些技术文字呀！

Chinese.Doll 发表于 2024-7-31 11:35:21

！上向天天，习学好好
页: [1]
查看完整版本: 毒药存储过程