OPENQUERY and Variables

• David-155102

  SSCarpal Tunnel

  Points: 4361

  More actions

  May 10, 2007 at 7:05 am

  #173592

  I need to build a statement at run-time and then execute the statement on a remote server. Unfortunately, I have been unable to achieve this using OPENQUERY because it does not accept variables as parameters. Does anyone know of another way of achieving this?

  Thanks

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 10, 2007 at 8:28 am

  #705511

  The only other way would be build the string dynamically.

• David-155102

  SSCarpal Tunnel

  Points: 4361

  More actions

  May 10, 2007 at 8:32 am

  #705514

  Hi Antares,

  I had a look at the following in the end which helped:

  http://support.microsoft.com/kb/314520

  Thanks for your response.