Sql update query doesn't fire update trigger for all records

2k Views Asked by At

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

1

There are 1 best solutions below

0
Ovais On

Finally got the answer,

Trigger fire once for single query execution. mass or bulk update/insert/delete will not awake trigger for every row