新账号自动送金币-奇迹MU数据库触发器语句

31分钟前奇迹MU教程 4

新帐号统一送钱到仓库触发器

CREATE TRIGGER 新帐号统一送钱到仓库触发器 ON warehouse
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE warehouse SET Money=需要送的钱数
FROM Inserted
WHERE warehouse.accountid=inserted.accountid
SET NOCOUNT OFF

新角色统一送钱到身上触发器

CREATE TRIGGER 新角色统一送钱到身上触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Money=需要送的钱数
FROM Inserted
WHERE Character.accountid=inserted.accountid
and Character.name=inserted.name
SET NOCOUNT OFF