更新数据

update MobileInfo.dbo.RolePopedom   set MobileInfo.dbo.RolePopedom.[Id] = b.[Id]  from mobile001.dbo.RolePopedom b   where MobileInfo.dbo.RolePopedom.RoleId=b.RoleId and MobileInfo.dbo.RolePopedom.PopedomId = b.PopedomId

 

 

insert into MobileInfo.dbo.UserInfo (ID,UserName,Password,RealName,Sex,BirthDate,OfficialPhone,Fax,MobilePhone,IsDirector,Flag,DepartmentCode,InfoCheckedNumber)

select  ID,Name,Password,ShortName,Sex,BirthDate,OfficialPhone,Fax,MobilePhone,IsDirector,Flag, DepartmentCode,InfoCheckedNumber from  OPENDATASOURCE(
  'SQLOLEDB',
  'Data Source=DIABLO;User ID=sa;Password=sa'
  ).mobile001001001001.dbo.UserInfo

 

update mo.b,mo.c from mo,ml where mo.a=mo.b

update  set a.[ID] = b.[Id]  from MobileInfo.dbo.Popedom  a,mobile001001001001.dbo.Popedom  b  where a.RoleId=b.RoleId and a.PopedomID = b.PopedomID

select  Id,PopedomName,ParentPopedomId,PopedomUrl,PicUrl  from  OPENDATASOURCE(
  'SQLOLEDB',
  'Data Source=DIABLO;User ID=sa;Password=sa'
  ).mobile001001001001.dbo.Popedom

insert into MobileInfo.dbo.Rolepopedom (RoleId,PopedomID)

select  RoleId,PopedomId  from  OPENDATASOURCE(
  'SQLOLEDB',
  'Data Source=DIABLO;User ID=sa;Password=sa'
  ).mobile001001001001.dbo.RolePopedom