Rows affected not be summed up
When you do an insert and it fires a trigger, the rows affected returned is a lump sum. In SSMS, each row affected is a separate output. So for example, you would get the number of rows the 1st trigger caused and the the actual inserted rows in the prime table. Same applied to update and delete actions.
3
votes
Anonymous
shared this idea