Reputation: 41
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
I'm using SQL Server 2008 Express edition-
Please guide me where I am wrong
Upvotes: 0
Views: 2158
Reputation: 41
Finally got the answer,
Trigger fire once for single query execution. mass or bulk update/insert/delete will not awake trigger for every row
Upvotes: 2