如何在Sql Server中访问链接的服务器表 [英] How Do I Access Linked Server Tables In Sql Server

问题描述

我通过局域网创建了一个链接服务器，

I have created a Linked server through LAN,

Linked server Name-[DELL-PC]

在这里，我无法运行此查询来从链接服务器中选择值

Here, I'm not able to run this query to select Values from Linked server

case :1
    select *From  [DELL-PC].[BTS_Server].[dbo].Assy_ProductionOrder_ParameterSetting
    select *From  [DELL-PC].[BTS_Server]..Assy_ProductionOrder_ParameterSetting

它说无效的对象名称'BTS_Server.dbo.Assy_ProductionOrder_ParameterSetting'。



但如果我使用openquery，它运作顺畅

it says "Invalid object name 'BTS_Server.dbo.Assy_ProductionOrder_ParameterSetting'."

but if i use openquery, it is working smoothly

case :2
    select *From openquery([DELL-PC],'Select *From [BTS_Server].[dbo].Assy_ProductionOrder_ParameterSetting ');

如何访问链接服务器表格如案例1语句，请帮助我。

How do i access linked server Table like case 1 statements, kindly assist me.

推荐答案

我尝试了动态查询，它对我有用

I tried it with dynamic query and it worked for me

declare @SqlServer  varchar(100)
declare @DatabaseName   varchar(100)

SET @query = @query + ' SELECT COUNT(*) FROM [@SqlServer

。[@ DB

.dbo.Table1

SET @query = replace（@query ，' @DB

.dbo.Table1 SET @query = replace(@query, '@DB

这篇关于如何在Sql Server中访问链接的服务器表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！