Jamie Thomson : Extracting insert, update, delete rowcounts from T-SQL MERGE

Just lately I’ve been using T-SQL’s MERGE statement (introduced in SQL Server 2008) and one thing that I needed to do was extract rowcounts for each DML operation (i.e. INSERT, UPDATE, DELETE) conducted by a MERGE. I was surprised to find that while ...

sqlblog.com