Kbase P145262: How to pass variable to OpenQuery on the MS SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/04/2009 |
|
Status: Unverified
GOAL:
How to pass variable to OpenQuery on the MS SQL Server
GOAL:
How to use variable with OpenQuery on the MS SQL Server for linked server
FACT(s) (Environment):
Progress/OpenEdge Database linked to the MS SQL Server
Windows
Progress 9.x
OpenEdge 10.x
OpenEdge SQL Category: SQL-92 Clients
FIX:
On the Transact-SQL (SQL Server query analyzer tool), use similar to the following syntax:
DECLARE @TSQL varchar(8000),@VAR varchar(100)
SELECT @VAR = 'some string'
SELECT @TSQL = 'SELECT * FROM OPENQUERY(linked_server_name,''SELECT * FROM pub.tableName WHERE field = ''''' + @VAR + ''''''')'
EXEC (@TSQL)