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

3 votes173 views3 answers
Into in sql
SQL
0 vote159 views1 answer
Postgresql parse json array
SQL
21 votes171 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote173 views1 answer
Sql find table by name
SQL
1 vote174 views1 answer
How to test for sql injection
SQL
0 vote166 views5 answers
Sql table intermédiaire
SQL
0 vote176 views1 answer
On sql table data exists
SQL
1 vote173 views1 answer
Sql server 2012 query history
SQL
0 vote173 views1 answer
How to to get current date in sql
SQL
0 vote193 views1 answer
Disable database droping sql
SQL