Including parameters in OPENQUERY

DECLARE @TSQL varchar(8000), @VAR char(2)
SELECT  @VAR = 'CA'
SELECT  @TSQL = 'SELECT * FROM OPENQUERY(MyLinkedServer,''SELECT * FROM pubs.dbo.authors WHERE state = ''''' + @VAR + ''''''')'
EXEC (@TSQL)

Source: stackoverflow.com

Similar codes

0 vote23 views1 answer
Mysql default uuid
SQL
0 vote39 views1 answer
Get role postgres
SQL
0 vote32 views1 answer
Mysql sum with group by
SQL
2 votes27 views1 answer
How to check grants on a package in oracle
SQL
0 vote32 views1 answer
Sql server select ignore dupplicates
SQL
2 votes29 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote34 views1 answer
Count characters of string mysql
SQL
12 votes44 views4 answers
How to check mysql version ubuntu
SQL
1 vote38 views2 answers
Truncate table sqlite
SQL
0 vote30 views1 answer
Oracle SQL join three tables and group by column
SQL