How do I use transactions in SQL?

How do I use transactions in SQL?

In SQL, transactions are used to ensure that a series of operations are completed successfully. You can start a transaction using the BEGIN TRANSACTION statement.

What commands do I need to use to commit or rollback a transaction?

To commit a transaction, use the COMMIT statement. If you need to undo changes, use the ROLLBACK statement.

Can you give me an example of a transaction?

Sure! Here's a simple example:

BEGIN TRANSACTION;
UPDATE accounts SET balance = balance - 100 WHERE account_id = 1;
UPDATE accounts SET balance = balance + 100 WHERE account_id = 2;
COMMIT;

This transfers $100 from account 1 to account 2.

What happens if an error occurs during the transaction?

If an error occurs, the transaction can be rolled back to ensure that no partial changes are saved, maintaining data integrity.