Post reply

How to pass LinkedServer Parameter to OpenQuery?

  • July 5, 2011 at 11:01 am

    #253998

    Hi, how can I pass a parameter for the LinkedServer to an openquery? I am receiving the following error:

    Incorrect syntax near '+@LinkedServer+'.

    declare @LinkedServer char(50)

    set @LinkedServer = 'Server1';

    select * from

    openquery

    (

    '+@LinkedServer+',

    'SELECT * from table1'

    )

    thank you in advance for your help,

  • July 5, 2011 at 11:39 am

    #1348492

    See this:

    http://www.sommarskog.se/dynamic_sql.html#OPENQUERY

  • July 5, 2011 at 11:40 am

    #1348495

    Hi Marcus,

    When trying to feed in dynamic Linked Servers you need to create a statement then execute that.

    declare @LinkedServer varchar(50), @sSQL varchar(200)

    set @LinkedServer = 'Server1';

    set @sSQL = 'select * from openquery('+@LinkedServer+',''SELECT * from table1'')'

    exec(@sSQL)

    Hope this helps.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply