查询链接的SQL Server [英] Querying a linked sql server

问题描述

我添加了一个链接服务器，该链接服务器显示在链接服务器列表中，但是当我查询它时，它会引发数据库服务器名称错误.

I added a linked server, which is showing in the linked server list, but when I query it, it throws an error with the db server name.

EXEC sp_helpserver
EXEC sp_addlinkedserver 'aa-db-dev01'
Select * from openquery('aa-db-dev01','Select * from TestDB.dbo.users')

第15级州立1行1的消息102
'aa-db-dev01'附近的语法不正确.

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'aa-db-dev01'.

推荐答案

SELECT * FROM [server].[database].[schema].[table]

这对我有用. SSMS intellisense可能仍将其强调为语法错误，但是如果已配置链接服务器并且查询正确，则它应该可以工作.

This works for me. SSMS intellisense may still underline this as a syntax error, but it should work if your linked server is configured and your query is otherwise correct.

这篇关于查询链接的SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！