SQL Server: Selecting 1 rows results in 1+3 rows affected?
i'm selecting 1 row from a table:
select开发者_StackOverflow中文版 * 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 select (especially since it returns only one row)?
Bonus information:
- SQL Server 2000
- LCTs is a real table (i.e. not a view or UDF)
- there is no triggers on the table
- this is SQL Server 2000, which has no DDL auditing
Even more bizarre is that if i update that one row:
update LCTs SET IsDirty = 1 WHERE LCTGUID = 'B642B9E6-779A-4FD0-8514-294EAF87A9A6'
(1 row(s) affected)
(5 row(s) affected)
How is an update of one row affecting 6 rows, in a table, without triggers, in SQL Server 2000?
This can happen if you have Show Actual Execution Plan
turned on. The second rowcount is for transferring the execution plan data.
精彩评论