Sql updating multiple tables

Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.

There is another way this one feature can be achieved is via transactions.First table ("names") Well, there is an immediate advantage in performing just a single SQL query instead of two, and I believe it is quite clear: the server will have a lighter work load.At the same time, we will have a full control on the performed operation, which will be faster and easier to maintain.You can wrap your around your more than one UPDATE statement in a single transaction, this way if one or more statement fails, the entire transaction rolls back.Here is the sample example of how the transaction should work with multiple update statements.