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.) |