How to Update Two tables with single statement in sql server ...

As I know you can not update two tables in one statement, but you can use transactions to create two ...

stackoverflow.com