Sql 更新查询不会触发所有记录的更新触发器 [英] Sql update query doesn't fire update trigger for all records

问题描述

我从 table1 触发器调用了更新查询，当该查询运行时，它成功更新了其他 table2，但 table2 的更新触发器仅触发了 1 次，这意味着不是针对从更新查询更新的每条记录

I called update query from table1 trigger, when that query runs, it updates other table2 successfully but update trigger of table2 is fired only 1 time means not for every record that was updated from query of update

我使用的是 SQL Server 2008 Express 版本-

I'm using SQL Server 2008 Express edition-

请指点我哪里错了

推荐答案

终于拿到了anwser :/, Trigger fire once for single query execution.批量或批量更新/插入/删除不会唤醒每一行的触发器 :(，我非常感谢 Markov 先生和 David Dubois 先生，他们有兴趣帮助我:) 谢谢亲爱的，

Finally got the anwser :/, Trigger fire once for single query execution. mass or bulk update/insert/delete will not awake trigger for every row :(, i really appreciate Mr. Markov & Mr. David Dubois, who showed interest in post to help me:) thanks dear,

这篇关于Sql 更新查询不会触发所有记录的更新触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！