This code snippet allow you to update table from another database in Microsoft SQL Server. To do this you have to use the following script.
UPDATE dbo.Address set gstnumber= t.gst
from olddb.dbo.address as t where dbo.address.id=t.id
All the data with corresponding id in the target table will be updated with the values of olddb database.
