MS-SQL/Query
[MSSQL] OPENQUERY와 파라미터를 대입하여 조회
Hwoarang757
2015. 3. 4. 18:41
-- 대입할 파라미터를 정의
DECLARE @PARAM1 NVARCHAR (4000)
SET @PARAM1 = 'TEST'
DECLARE @ORACLE_QUERY NVARCHAR(4000)
SET @ORACLE_QUERY = 'SELECT Column1 FROM OPENQUERY(ORACLE_DB,''SELECT Column1 FROM DBNAME.ROUTING WHERE COLUMNNAME =''''' + @PARAM1 + ''''''')';
DECLARE @RESULT TABLE
(
RESULT VARCHAR(40)
)
INSERT @RESULT
-- OPENQUERY 실행
EXEC (@ORACLE_QUERY )
SELECT * FROM @RESULT