请高手帮 解释 下以下 的代码 谢谢

USE REDMOON

GO

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


谢谢

帮翻译下 谢谢
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

－－上面两行是定义了两个整形的变量
select @BonusLevel = Lvl from tblGameID1 where GameID = @GameID －－当gameid=@gameid时将lvl的值付给@BonusLevel
IF @BonusLevel>1000

select @BonusLevel=1000－－当@BonusLevel>1000,使@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