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