Thursday, May 10, 2012

Cross Database Bulk Update

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  

No comments:

Post a Comment