MSSQL : Update row from another database
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.
View On WordPress















