How to update multiple tables in sql server 2008 ?

Question

I want to update data from one table to another table with year condition.
(OR)
To Update one table based on another table using INNER JOIN

Answer 1

You can not update multiple table in one single update statement.. what you can do is wrap the update statement in a transaction, commit changes only when both update are successful.
Here MSDN Visual Studio gives you a bypass on that.

https://msdn.microsoft.com/en-us/library/f5scy1hs(v=VS.80).aspx