跨服务器SQL语句执行

--exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','IP地址'

--exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','数据库密码'

select formid from srv_lnk.QxbtXH.dbo.nw_gform

--insert into srv_lnk.QxbtXH.dbo.nw_gform( FormID, FormName, ProgFormName, SYSID, ModuleID, DBID, FormOP, Queryform, controller, parameter,

              --  Memo, HDTable, DTTable, DealAfterSave )

select * from nw_gform where formid not in (select formid from srv_lnk.QxbtXH.dbo.nw_gform)

--insert into srv_lnk.QxbtXH.dbo.NW_Menu( menuid, menuname, formid, formtype, parentmenu, inactived, moduleid, memo, seq)

--select * from NW_Menu where menuid not in (select menuid from srv_lnk.QxbtXH.dbo.NW_Menu)

-- 创建数据库连接db_al

--exec sp_addlinkedserver 'db_al','','SQLOLEDB','IP地址'

--exec sp_addlinkedsrvlogin 'db_al','false',null,'sa','数据库密码'

select * from nw_menu where menuid not in (select menuid from db_al.QxbtXH.dbo.nw_menu)