Geek Answers Handbook

SQL Server: selecting 1 row will damage 1 + 3 rows?

I select 1 row from the table:

select * from LCTs WHERE LCTGUID = 'B642B9E6-779A-4FD0-8514-294EAF87A9A6' (1 row(s) affected) (3 row(s) affected)

How can I get 4 rows affected by a single selection (especially since it returns only one row)?

Bonus Information:

  • SQL Server 2000
  • LCT is a real table (i.e. not a view or UDF)
  • there are no triggers in the table
  • this is SQL Server 2000 that does not have DDL auditing

Even stranger, if I update one line:

 update LCTs SET IsDirty = 1 WHERE LCTGUID = 'B642B9E6-779A-4FD0-8514-294EAF87A9A6' (1 row(s) affected) (5 row(s) affected)

How is a single row updated that affects 6 rows in a table without triggers in SQL Server 2000?

+4
source share
1 answer

This can happen if you enable Show Actual Execution Plan . The second rowcount is for transferring execution plan data.

+10
source

More articles:


All Articles