USE master
GO
EXEC sp_addlinkedserver
'server2',
N'SQL Server'
GO
EXEC sp_addlinkedsrvlogin 'server2', 'false', NULL, 'Sa', 'pass'
GO
use tool
delete tb_ciq
into tb_ciq SELECT * FROM server2.tools.dbo.tb_ciq
go
GO
EXEC sp_addlinkedserver
'server2',
N'SQL Server'
GO
EXEC sp_addlinkedsrvlogin 'server2', 'false', NULL, 'Sa', 'pass'
GO
use tool
delete tb_ciq
into tb_ciq SELECT * FROM server2.tools.dbo.tb_ciq
go
GO
EXEC sp_addlinkedserver
'server2',
N'SQL Server'
GO
EXEC sp_addlinkedsrvlogin 'server2', 'false', NULL, 'Sa', 'pass'
GO
use tool
delete tb_ciq
into tb_ciq SELECT * FROM server2.tools.dbo.tb_ciq
go
'别名',
'',
'MSDASQL',
NULL,
NULL,
'DRIVER={SQL Server};SERVER=远程名;UID=用户;PWD=密码;'
GOinsert into b(col1,col2....)
select col1,col2,col3.... from 别名...table