반응형
/********************************************************************************************
-- Title : [2k5] EXEC~ AT~을 이용한 PathThrough 구현
-- Reference : bol
-- Key word : sql server exec at paththrough execute at
********************************************************************************************/
-- 원격 쿼리의 PathThrough 구현 방법...
-- Title : [2k5] EXEC~ AT~을 이용한 PathThrough 구현
-- Reference : bol
-- Key word : sql server exec at paththrough execute at
********************************************************************************************/
-- 원격 쿼리의 PathThrough 구현 방법...
-- Setup the linked server.
EXEC sp_addlinkedserver @server='ORACLE',
@srvproduct='Oracle',
@provider='OraOLEDB.Oracle', @datasrc='ORACLE10';
EXEC sp_addlinkedsrvlogin @rmtsrvname='ORACLE',
@useself='false',
@locallogin=null,
@rmtuser='scott',
@rmtpassword='tiger';
EXEC sp_serveroption 'ORACLE', 'rpc out', true;
GO
-- Execute several statements on the linked Oracle server.
EXEC ( 'SELECT * FROM scott.emp') AT ORACLE;
GO
EXEC ( 'SELECT * FROM scott.emp WHERE MGR = ?', 7902) AT ORACLE;
GO
DECLARE @v INT;
SET @v = 7902;
EXEC ( 'SELECT * FROM scott.emp WHERE MGR = ?', @v) AT ORACLE;
GO반응형