반응형
/**********************************************************************************************
-- 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
반응형