如何在SQL Server中加入两个不同的服务器表 [英] How do join two different server's table in SQL server

问题描述

我想加入不同服务器上的两个表。



错误是：

I want to join the two tables on different server.

Error is:

Could not find server '223.30.10.75' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

我尝试过：

What I have tried:

select paycode,in1,out2 from tbltimeregister 
inner join [223.30.10.75].[testhr].[dbo].[employeemaster] on tbltimeregister.paycode=employee_id
where dateoffice= convert (varchar,getdate()-2,106) and in1 is not null
order by paycode

推荐答案

链接服务器 [ ^ ]就是您所需要的。请参阅：如何创建链接服务器 [ ^ ]



之后taht您将能够从该链接服务器获取数据：

Linked server[^] is all what you need. See: How to Create a Linked Server[^]

After taht you'll be able to get data from that linked server:

select tr.paycode, tr.in1, em.out2
from tbltimeregister tr inner join [testhr].[dbo].[employeemaster] em on tr.paycode=em.employee_id

这篇关于如何在SQL Server中加入两个不同的服务器表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！