连接一台服务器,然后再访问另一台:
USE master
GO
EXEC sp_addlinkedserver
'another',
N'SQL Server'
GO
EXEC sp_addlinkedsrvlogin 'another', 'false', NULL, 'Sa', 'Pass'
GOuse dbname
SELECT * FROM another.dbname.dbo.table1 as A, table2 as B
where A.id = B.id
USE master
GO
EXEC sp_addlinkedserver
'another',
N'SQL Server'
GO
EXEC sp_addlinkedsrvlogin 'another', 'false', NULL, 'Sa', 'Pass'
GOuse dbname
SELECT * FROM another.dbname.dbo.table1 as A, table2 as B
where A.id = B.id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货