반응형
/**********************************************************************************************
-- Title : [2k5] EXECUTE AT 사용 및 동적 쿼리 활용 예
-- Reference : bol, dbrang.com
-- Key word : sql server execute at exec at paththrough path through
**********************************************************************************************/
-- 오라클 원격 서버 설정
EXEC sp_dropserver linked_oracle, droplogins;
go
 
EXEC sp_addlinkedserver         
  @server='linked_oracle'
, @srvproduct='Oracle'
, @provider='ORAOLEDB'
, @datasrc='61.73.xx.xxx';
go
 
EXEC sp_addlinkedsrvlogin    
  @rmtsrvname='linked_oracle'
, @useself='false'
, @locallogin=null
, @rmtuser='welib'
, @rmtpassword='password';
 
EXEC sp_serveroption 'linked_oracle', 'rpc out', true;
-- EXEC AT 테스트
EXEC ( 'SELECT * FROM welib.tab') AT linked_oracle;
GO
 
EXEC ( 'SELECT * FROM welib.emp WHERE MGR = ?', 7902) AT linked_oracle;
GO

DECLARE @v INT;
SET @v = 7902;
EXEC ( 'SELECT * FROM welib.emp WHERE MGR = ?', @v) AT linked_oracle;
GO
반응형

+ Recent posts