How to Write a Query to Update a Table from Multiple DataBase on Same SQL Server

@pmango2 (156)
India
September 5, 2006 6:21am CST
How to Write a Query to Update a Table from Multiple dataBase on Same SQL Server
2 responses
zahir_dk
@zahir_dk (1693)
• India
12 Sep 06
To update two tables from Multiple db's on same SQL Server use will have to use DatabaseName.dbo.TableName Hope it will help you.
ShahidBabar
@ShahidBabar (1)
• Pakistan
12 Sep 06
you can write update query by joining multiple tables its general syntax is update table1 set colofTable1=value from table1 ,table2 where table1.coljoining=table2.coljoining i think it will work for you