01 How to Catch and Roll Back Errors

Let’s say you need to insert rows into two tables at the same time, and you have to make absolutely sure that either both of them are inserted, or neither of them are. We’ll start by seeing why TRY/CATCH and transactions don’t make this happen, and why you need to make a turkey sandwich with…