可以使用SQL语句进行更新（代码如下）
USE REDMOON
UPDATE TBLGAMEID1
SET StoryQuestState=131071
(OK,全部都解除任务了)

新建人物1级任务值就满了。
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
如果把红色字部分改成>49号..大于49级的所有人物任务值都满
不想要了话就执行： DROP TRIGGER TR_UPDATE_TBLGAMEID1
=======================================
我家里没有3.8的数据库，做不了测试，如果报错的话再告诉我
use redmoon
go
CREATE TRIGGER TR_INSERT_TBLGAMEID1 ON TBLGAMEID1
FOR INSERT
AS
UPDATE TBLGAMEID1 SET StoryQuestState=131071 WHERE GAMEID IN (SELECT GAMEID FROM INSERTED)
不想要了话就执行：DROP TRIGGER TR_INSERT_TBLGAMEID1

CREATE TRIGGER [TRIGGER-QUEST] ON dbo.tblGameID1
FOR INSERT
AS
BEGIN
DECLARE @GAMEID CHAR(14)
SELECT @GAMEID= GAMEID FROM INSERTED
BEGIN
UPDATE TBLGAMEID1 SET SETimer='3:957000.8:932000.17:2062000.25:1979000.26:33532437.33:2468000.42:1967000.44:2036000.45:2016000.53:2079000.58:5000.64:3035000.67:2094000.76:2085000.' WHERE GAMEID IN (SELECT GAMEID FROM INSERTED)
END
END
上线送魔法

1152452856@qq.com求端