常用各种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 | 网页链接