Home Forums SQL Server 2005 T-SQL (SS2K5) Pass variable to Openquery RE: Pass variable to Openquery

  • October 26, 2012 at 8:10 am

    #1553191

    Try the following syntax

    declare @string varchar(max)

    set @string = 'abcd'

    select * from openquery

    (TEST_Server, 'select * from Table1 where Field1 = ' + @string + '')