--创建链接服务器
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','远程服务器名或ip地址'
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'用户名','密码'
gocreate proc up_test
as
insert into srv_lnk.dtname.dbo.表
select * from 表
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','远程服务器名或ip地址'
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'用户名','密码'
gocreate proc up_test
as
insert into srv_lnk.dtname.dbo.表
select * from 表
select ... from tabelName where ....