Hi all,
Does anyone know if it is possible to pass variabes to an openquery statement?
I am trying to do something like this:
OPENQUERY(LinkServer, 'SELECT column1, column2 FROM table WHERE column3 ='' + @.@.variable1 +'' AND column4 = '' +@.@.variable2 +'')
Many thanks in advance,
-Vicky
Hi vicky,
If you are using SS 2005, then take a look to EXEC in BOL. You can use the "at linked_server_name" feature and use also parameters. If you are using 2000, then you will have to deal with dynamic sql.
The Curse and Blessings of Dynamic SQL
http://www.sommarskog.se/dynamic_sql.html#OPENQUERY
AMB
|||Thanks a lot!. This was helpful.