-- Select
SELECT * FROM OPENQUERY(LINKED_NAME, 'SELECT * FROM test_tbl');
 
-- Insert
INSERT OPENQUERY(LINKED_NAME, 'SELECT ID, NAME FROM test_tbl ') VALUES (1, 'name');
 
INSERT OPENQUERY(MYORACLE, 'SELECT * FROM emp ')
SELECT 1, '10000', '테스트'
;
 
-- Update
UPDATE OPENQUERY(LINKED_NAME, 'SELECT NAME FROM test_tbl WHERE ID = 1') SET NAME = 'value';
 
-- Delete
DELETE FROM OPENQUERY(LINKED_NAME, 'SELECT ID FROM test_tbl WHERE ID = 1');
 
 
--참조프로시저 : SP_DEBIS_INSERT
--DB 호환
--sp_helpdb