I sometimes perform the following set of statement in the following order: Raiseerror(...) Rollback; but I am wondering if it …