SQL更新查询不会触发所有记录的更新触发器

问题描述

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

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：/，为单个查询执行触发一次触发。批量更新或批量更新/插入/删除不会为每行唤醒：(，我非常感谢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更新查询不会触发所有记录的更新触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！