This would be a prime example of one to wrap in a transaction: Using Transactions for Data Changes via SQL