[2k5] EXEC~ 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