在其他情况下查询数据源 [英] Querying the datasource in other instance

问题描述

在链接服务器的情况下，是否可以通过其他方式从数据源查询表?有没有办法做到这一点，我看到我们可以处理分布式查询，有人可以帮我提供一些示例示例或参考链接吗?谢谢

解决方案

使用链接服务器您需要做的就是使用完全限定的表名来访问它:

服务器(或方括号中的IP地址).database.owner(最常见的是dbo).table

这将像访问同一台服务器一样访问该表.像:

SELECT ... FROM linkedservername.databasename.objectownername.tablename...

is there a way i can query a table from datasource wich is in other instance in case of linked servers? is there a way to do it i saw we can do with distributed queries ,can some one help me with some sample example or refrence links thanks

解决方案

With a linked server all you need to do is use the fully qualified table name to access it:

Server(or ip address in square brackets).database.owner(most commonly dbo).table

This will access the table as if it was on the same server.

Your question isn''t very clear but if you have defined a linked server then you can use it in the sql statements like:

SELECT ... FROM linkedservername.databasename.objectownername.tablename...

这篇关于在其他情况下查询数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！