CREATE TRIGGER TR_UPDATE_TBLGAMEID1 ON TBLGAMEID1 FOR UPDATE AS IF UPDATE(Lvl) BEGIN DECLARE @GAMEID CHAR(14) DECLARE @LEVEL INT DECLARE crGAMEID CURSOR FOR SELECT GAMEID,LVL FROM INSERTED OPEN crGAMEID FETCH NEXT FROM crGAMEID INTO @GAMEID,@LEVEL WHILE @@fetch_status = 0 BEGIN IF @LEVEL=1000 BEGIN UPDATE TBLGAMEID1 SET OPArmy=1 WHERE GAMEID=@GAMEID END FETCH NEXT FROM crGAMEID INTO @GAMEID,@LEVEL END close crGAMEID deallocate crGAMEID END
发表于 2011-9-28 12:19:54
发表于 2011-9-30 02:01:04
