Mangesh barmate

Mangesh barmate

  • 2.1k
  • 118
  • 126.6k

How to update multiple tables in sql server 2008 ?

Mar 8 2013 9:03 AM
 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
and = '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!


Answers (2)