As documented, when using INSERT ... ON EXISTING SKIP, the value of @@ROWCOUNT still does count all rows from the source table:
Is there a possibility to get only the count of the really inserted rows (besides merely counting the tables's rows before and after the statement)? If not, is this considered as a future enhancement? (FWIW, I'm using SA 12.0.0.2601.) asked 20 Jan '11, 10:04 Volker Barth |
Volker, The enhancement you are suggesting seems quite reasonable if you are using "EXISTING SKIP" since the @rowcount is supposed to be the number of rows affected. I will open an enhancement request and we will try and get the enhancement in place for a future release. Karim answered 20 Jan '11, 15:16 Karim Khamis 1
Just to follow up, this "bug" has now been fixed. The fix has been put into 10.0.1.4174, 11.0.1.2552 and 12.0.0.2637. |