How to update multiple tables in sql server 2008 ?

Question

Hi All I want to update multiple columns from multiple tables in a single UPDATE Query... Just want to do like below query... UPDATE Table1 Table2 SET Table1.Column1 = 'one' Table2.Column2 = 'two' FROM Table1 T1 Table2 T2 WHERE T1.id = T2.id and T1.id = 'id1' Does Sql Server 2008 provide any mechanism to do so? If Sql Server 2008 provide such nice approach please share some links with me! Thanks!

venkata kumar · Answer

hi you can use stored procedure by using that at a time you can execute one or more tables can upate

Mohamed Gani Mn · Answer

You can this query followed by one or more table using commit transaction BEGIN TRANSACTION UPDATE Table1 SET Table1 . Column1 = 'name' FROM Table1 T1  Table2 T2 WHERE T1 . id = T2 . id and T1 . id = '100' UPDATE Table2 SET Table2 . EntityName = 'watch' FROM Table1 T1  Table2 T2 WHERE T1 . id = T2 . id and T1 . id = '100' COMMIT