begin transaction and
exec a stored procedure, does that transaction cover the changes made by the stored procedure I executed? Would a
rollback transaction cancel the changes made by the stored procedure which is executed?
but still lead to the transaction being committed. Both cases shown below.