Tuesday, March 24, 2015

How To Update One DataBase Table To Another DataBase Table In SQL

USE db1
go
UPDATE t1 SET DateOfRegistration = t2.DateOfRegistration
FROM db1.TableName1 t1
JOIN db2.TableName2 t2
ON t1.IDP = t2.IDP

No comments :

Post a Comment