战士.磨剑.圣导上线送300点,法师.MM上线送600点 SQL触发器
战士.磨剑.圣导上线送300点,法师.MM上线送600点 SQL触发器
CREATE TRIGGER 战士送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=600
FROM Inserted
Where Inserted.Class=16
and Character.name=Inserted.name
SET NOCOUNT OFF
CREATE TRIGGER 法师送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=1200
FROM Inserted
Where Inserted.Class=0
and Character.name=Inserted.name
SET NOCOUNT OFF
CREATE TRIGGER 精灵送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=1200
FROM Inserted
Where Inserted.Class=32
and Character.name=Inserted.name
SET NOCOUNT OFF
CREATE TRIGGER 战士送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=300
FROM Inserted
Where Inserted.Class=16
and Character.name=Inserted.name
SET NOCOUNT OFF
CREATE TRIGGER 魔剑送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=1200
FROM Inserted
Where Inserted.Class=48
and Character.name=Inserted.name
SET NOCOUNT OFF
CREATE TRIGGER 圣导送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=800
FROM Inserted
Where Inserted.Class=64
and Character.name=Inserted.name
SET NOCOUNT OFF
CREATE TRIGGER 召唤送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=600
FROM Inserted
Where Inserted.Class=80
and Character.name=Inserted.name
SET NOCOUNT OFF
CREATE TRIGGER 角斗士送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=800
FROM Inserted
Where Inserted.Class=96
and Character.name=Inserted.name
SET NOCOUNT OFF
分别5次运行
另外圣导出生统率SQL语句
圣导师送9999统率(MS SQL分析)
复制以下代码，打开SQL查询分析器
适合所有奇迹服务端
CREATE TRIGGER [Leadership] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].Leadership=999
From Inserted
Where Inserted.Class=64 and [Character].accountid=inserted.accountid
and [Character].name=inserted.name最后更新于 2022-05-25 21:28:25 并被添加「sql SQL触发器」标签，已有 724 位童鞋阅读过。
本站使用「署名 4.0 国际」创作共享协议，可自由转载、引用，但需署名作者且注明文章出处