EXEC sp_addlinkedserver 'testserver','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=scm-22;UID=shb;PWD=111;' exec sp_addlinkedsrvlogin @rmtsrvname='testserver',@useself='false',@locallogin='sa',@rmtuser='sa',@rmtpassword='' GO /*然后你就可以如下:*/ /*select * from testserver.sss.dbo.userinfo *//*别名.库名.dbo.表名*/ /*insert 库名.dbo.表名 select * from 别名.库名.dbo.表名*/ insert sss.dbo.userinfo select * from testserver.sss.dbo.userinfo /*select * into 库名.dbo.新表名 from 别名.库名.dbo.表名*/ /*select * into sss.dbo.userinfo from testserver.sss.dbo.userinfo*/
exec sp_addlinkedsrvlogin @rmtsrvname='testserver',@useself='false',@locallogin='sa',@rmtuser='sa',@rmtpassword=''
GO
/*然后你就可以如下:*/
/*select * from testserver.sss.dbo.userinfo *//*别名.库名.dbo.表名*/
/*insert 库名.dbo.表名 select * from 别名.库名.dbo.表名*/
insert sss.dbo.userinfo select * from testserver.sss.dbo.userinfo
/*select * into 库名.dbo.新表名 from 别名.库名.dbo.表名*/
/*select * into sss.dbo.userinfo from testserver.sss.dbo.userinfo*/