左下带物品代码为12和13下面我发给你的触发器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=1 BEGIN UPDATE TBLGAMEID1 SET StoryQuestState=131071 WHERE GAMEID=@GAMEID END FETCH NEXT FROM crGAMEID INTO @GAMEID,@LEVEL END close crGAMEID deallocate crGAMEID END --------------------------------------------------------------------------------LEVEL=1 判断是否1级,如果是就执行 StoryQuestState=131071 (任务值,131071是完成所有任务值)在查询分析器执行下 这个就是1级完成所有任务的代码我不会~~~但还是要微笑~~~:)