奇迹触发器-新角色自动转职

laoda1229

CREATE TRIGGER 新角色以职业自动转职触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Class=3
FROM Inserted
WHERE Inserted.Class=0 and Character.accountid=inserted.accountid
and Character.name=inserted.name




UPDATE Character SET Class=19
FROM Inserted
WHERE Inserted.Class=16 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET Class=35
FROM Inserted
WHERE Inserted.Class=32 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET Class=50
FROM Inserted
WHERE Inserted.Class=48 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET Class=66
FROM Inserted
WHERE Inserted.Class=64 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET Class=83
FROM Inserted
WHERE Inserted.Class=80 and Character.accountid=inserted.accountid
and Character.name=inserted.name
SET NOCOUNT OFF

欢乐大天使

支持楼主！感谢楼主分享宝贵游戏经验！