The SSMS shows an extra (1 row(s) affected)
every time when I execute insert/update
. For example, execute the following SQL
declare @a table (a int)
insert into @a values (1), (2)
update @a set a = 3
And the SSMS will display the following message.
(2 row(s) affected) (1 row(s) affected) (2 row(s) affected) (1 row(s) affected)
I didn't find any database/server trigger. What could cause the extra (1 row(s) affected)
?