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 · Accepted 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