USE db1
go
UPDATE t1 SET DateOfRegistration = t2.DateOfRegistration
FROM db1.TableName1 t1
JOIN db2.TableName2 t2
ON t1.IDP = t2.IDP
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