Passing variable in OPENQUERY for a linked server name

Question

How can I pass Linked server name as a variable?

something like this:

declare @A varchar(55) = 'LinkedServerName'

select * from OPENQUERY(@A,'select 1')

Does this answer your question? OPENQUERY(SERVERNAME, STOREDPROCEDURE) Syntax error — Michael Freidgeim
– Michael Freidgeim, Commented Oct 29, 2021 at 22:04

rakamakafo · Accepted Answer · 2016-08-29 17:14:31Z

1

This helped. Here I have to create variable for the whole openquery, and than excute it by dynamic SQL. https://support.microsoft.com/en-us/kb/314520

answered Aug 29, 2016 at 17:14

rakamakafo

1,1547 gold badges21 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1