同局域网存储过程调用另一服务器数据库

 create procedure InsertOnLineGame

as
begin
  delete from iTVSysEPG.dbo.OnlineGameTop
  insert into iTVSysEPG.dbo.OnlineGameTop(UserID,UserNick,UserSore,UserExp,GameId) select top 10 b.UserID,b.UserNick,a.score,b.UserExp,1 as GameId from ( select * from opendatasource('SQLOLEDB' , 'Data Source=IP地址; User ID=数据库用户名;Password=密码').game_waken.dbo.waken_iptv)as a join  iTVSysEPG.dbo.Users  as b on cast(b.XkUserID as varchar) =a.userid and a.robotid =0 and LEN(a.nick)=11  order by a.score  desc
  insert into iTVSysEPG.dbo.OnlineGameTop(UserID,UserNick,UserSore,UserExp,GameId) select top 10 b.UserID,b.UserNick,a.score,b.UserExp,2 as GameId from ( select * from opendatasource('SQLOLEDB' , 'Data Source=IP地址; User ID=数据库用户名;Password=密码').game_waken.dbo.feixingqi_iptv)as a join  iTVSysEPG.dbo.Users  as b on cast(b.XkUserID as varchar) =a.userid and a.robotid =0 and LEN(a.nick)=11  order by a.score  desc
  insert into iTVSysEPG.dbo.OnlineGameTop(UserID,UserNick,UserSore,UserExp,GameId) select top 10 b.UserID,b.UserNick,a.score,b.UserExp,13 as GameId from ( select * from opendatasource('SQLOLEDB' , 'Data Source=IP地址; User ID=数据库用户名;Password=密码').game_waken.dbo.mahjongxa_iptv)as a join  iTVSysEPG.dbo.Users  as b on cast(b.XkUserID as varchar) =a.userid and a.robotid =0 and LEN(a.nick)=11  order by a.score  desc
  insert into iTVSysEPG.dbo.OnlineGameTop(UserID,UserNick,UserSore,UserExp,GameId) select top 10 b.UserID,b.UserNick,a.score,b.UserExp,14 as GameId from ( select * from opendatasource('SQLOLEDB' , 'Data Source=IP地址; User ID=数据库用户名;Password=密码').game_waken.dbo.texan_iptv)as a join  iTVSysEPG.dbo.Users  as b on cast(b.XkUserID as varchar) =a.userid and a.robotid =0 and LEN(a.nick)=11  order by a.score  desc
  insert into iTVSysEPG.dbo.OnlineGameTop(UserID,UserNick,UserSore,UserExp,GameId) select top 10 b.UserID,b.UserNick,a.score,b.UserExp,101 as GameId from ( select * from opendatasource('SQLOLEDB' , 'Data Source=IP地址; User ID=数据库用户名;Password=密码').game_waken.dbo.texan_iptv)as a join  iTVSysEPG.dbo.Users  as b on cast(b.XkUserID as varchar) =a.userid and a.robotid =0 and LEN(a.nick)=11  order by a.score  desc
  insert into iTVSysEPG.dbo.OnlineGameTop(UserID,UserNick,UserSore,UserExp,GameId) select top 10 b.UserID,b.UserNick,a.p_Coin,b.UserExp,22 as GameId from ( select * from opendatasource('SQLOLEDB' , 'Data Source=IP地址; User ID=sa;Password=3269622').itv_tc.dbo.vw_PlayerData)as a join  iTVSysEPG.dbo.Users  as b on b.UserID =a.UserID  order by a.p_Coin  desc
  end