Update two tables at once on a Join - SQL Server Q&A from the SQL Server Central community

I only add to @Kev. When you will wrap two update statements into a transaction, take care about the XACT_ABORT settings. It should be set to ON to be sure, that the whole transaction is rolled back whenever any of the statements fail and you will not han

ask.sqlservercentral.com