How to update two tables in one query in MS SQL

Question

Is it possible to update two tables that write a single query?

So, I do not need to fulfill two requests and track whether both of them are successful?

Answer 1

You cannot do this in a request, but you can do it as a transaction when all requests in a transaction are either successful or unsuccessful.

Answer 2

You can write a stored procedure that updates two tables and returns everything you need to determine success. Then this stored procedure can be called from one command. However, it should still contain two queries.

Answer 3

No, this is impossible AFAIK.

EDIT: what is the reason for achieving this in a single query?

Answer 4

You can use transactions , but you still need to update the tables separately and check the results before executing or rolling back.

Answer 5

Of course you can use triggers