多表对应更新（跨服务器）.sql

update r_RightList set MenuPos=( select  MenuPos
from OPENROWSET('SQLOLEDB',
'SERVER=219.139.49.10;uid=sa;pwd=;Database=','select * from r_RightList') as a
  where r_RightList.RightCode=a. RightCode)