In SQL server- Query Analyzer when you do a delete from table sql command in SQL you get
ie. (25 rows(s) affected). which is the norm. But for a specific table that I perfom a delete from table sql command I get something different. For example say the table has 3 records that I need to remove, so when I perform the delete from table where x=3 sql command it displayes the following:
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(3 rows(s) affected)
It looks like it performs an extra transaction for each record I need to remove. it even takes more time to remove, yes the table has foreign key restrictions. I never seen this happen
when I try the delete command. Can someone please explan, is this a special kind of table?
Thanks.
Start Free Trial
