Comment by chris_wot

Er, wouldn’t you do all the updates in a single transaction? If one fails then it rolls back all the changes.