Every query that you run on a SQL database that modifies data in some way, has the potential of causing damage if it has not been written correctly.

Luckily for us, there are a few commands that can be used in order to help prevent this type of user error.

BEGIN TRANSACTION - Run this before running your query.

COMMIT TRANSACTION - Run this after running your query, only if it was successful and did what you wanted it to.

ROLLBACK TRANSACTION - Run this is your query did something nasty.