• I think inside the begin trans...commit, it all are counted as a single transaction. Hence 1 row is affected.

    Thanks.