Ovais
Ovais

Reputation: 41

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

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

Answers (1)

Ovais
Ovais

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

Related Questions