Bulk Updating the Record of Table of One DataBase to Another
update DataBaseone.UM_Users
set DataBaseone.UM_Users.Name = B.Name
from DataBaseone.UM_Users as A,DataBaseTwo.UM_Users as B
where A.UserId = B.UserId
update DataBaseone.UM_Users
set DataBaseone.UM_Users.Name = B.Name
from DataBaseone.UM_Users as A,DataBaseTwo.UM_Users as B
where A.UserId = B.UserId
No comments:
Post a Comment