Search results

I write this trigger, use if hp=0 (player die) CREATE TRIGGER [TExp] ON [dbo].[TBL_ABILITY] FOR UPDATE AS begin if UPDATE (FLD_HP) begin if (select FLD_HP from inserted )=0 begin Declare @lvl smallint select @lvl=FLD_LEVEL from inserted if (1<=@lvl and @lvl<20) update...