常用各种SQL触发脚本
CREATE TRIGGER 新角色统一送自由分配点触发器 ON Character
UPDATE Character SET LevelUpPoint=需要送的点数
------------------------------------------------------------------
CREATE TRIGGER 新角色以职业送自由分配点触发器 ON Character
UPDATE Character SET LevelUpPoint=法师需要送的点数
UPDATE Character SET LevelUpPoint=战士需要送的点数
UPDATE Character SET LevelUpPoint=弓箭需要送的点数
UPDATE Character SET LevelUpPoint=魔剑需要送的点数
UPDATE Character SET LevelUpPoint=圣导需要送的点数
UPDATE Character SET LevelUpPoint=召唤需要送的点数
-----------------------------------------------------------------------
CREATE TRIGGER 新圣导角色送统率触发器 ON Character
UPDATE Character SET Leadership=需要送的点数
--------------------------------------------------------------------------------------
CREATE TRIGGER 新帐号统一送钱到仓库触发器 ON warehouse
UPDATE warehouse SET Money=需要送的钱数
CREATE TRIGGER 新角色统一送钱到身上触发器 ON Character
UPDATE Character SET Money=需要送的钱数
-----------------------------------------------------------------------------------------
CREATE TRIGGER 新角色自动送转触发器 ON Character
UPDATE Character SET 保存转身次数表项名称=需要送的转数
WHERE Inserted.保存转身次数表项名称=0 and Character.accountid=inserted.accountid
and Character.name=inserted.nameSET NOCOUNT OFF
--------------------------------------------------------------------------------------------------
CREATE TRIGGER 法师自动三转触发器 ON Character
-----------------------------------------------------------
CREATE TRIGGER 战士自动三转触发器 ON Character
CREATE TRIGGER 弓箭自动三转触发器 ON Character
----------------------------------------------------------------------------------
CREATE TRIGGER 魔剑自动三转触发器 ON Character
CREATE TRIGGER 圣导自动三转触发器 ON Character
-------------------------------------------------------------------------------------
CREATE TRIGGER 召唤自动三转触发器 ON Character
附件:qnupload.zip | 网页链接