This blog post will cover a simple example of using a TRANSACTION
along with user-defined session variables to greatly reduce the chance for errors on our part when updating multiple database tables.
Note: All data, names or naming found within the database presented in this post, are strictly used for practice, learning, instruction, and testing purposes. It by no means depicts actual data belonging to or being used by any party or organization.