To compare the two, by default if you nest transactions and rollback from an inner transaction, there is only a single transaction in use, so it rolls the entire transaction back.