>What do I need transactions to begin with??

Say you're doing an invoice, and you're adding a header record and several detail records. The header updates correctly, but not all of the detail lines. If you include those in a transaction, you can roll them all back, even after you've committed the updates on several records. The transaction as a whole isn't saved to the tables until the END TRANSACTION statement.