SELECT *
FROM
OPENROWSET('SQLOLEDB',
'server=ServerNsme;Database=DatabaseName;uid=UserID;pwd=Password;',
'SELECT * FROM dbo.Ptest2'),dbo.Ptest1
FROM
OPENROWSET('SQLOLEDB',
'server=ServerNsme;Database=DatabaseName;uid=UserID;pwd=Password;',
'SELECT * FROM dbo.Ptest2'),dbo.Ptest1
EXEC sp_addlinkedserver '别名','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=远程名;UID=用户;PWD=密码;'
exec sp_addlinkedsrvlogin @rmtsrvname='别名',@useself='false',@locallogin='sa',@rmtuser='sa',@rmtpassword='密码'
GO
然后你就可以如下:
select * from 别名.库名.dbo.表名
insert 库名.dbo.表名 select * from 别名.库名.dbo.表名
select * into 库名.dbo.新表名 from 别名.库名.dbo.表名
go