Posted on 2008-05-23 10:35
W.R 阅读(336)
评论(0) 编辑 收藏 所属分类:
支持技术
exec sp_addlinkedserver 'link_sql2','','SQLOLEDB','127.0.0.1;
exec sp_addlinkedsrvlogin 'link_sql2','false',null,'sa','sa';
select *from Table1
insert into [link_sql2].OSS.dbo.Table1 select *from Table1