Linked Server

 

Linked Server in SQL Server Management Studio.

 

Ex. Select Query

select * from [SAPDEV]..[SAPDEV].[ZHST_MID]

 

Ex. Insert Query

INSERT into  OPENQUERY (SAPDEV, 'select * from SAPDEV.ZHST_MID')
values ('210','M002','Test','TT',' ',' ',' ')

INSERT OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles')
VALUES ('NewTitle')

Ex. Update Query

UPDATE OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles WHERE id = 101') 
SET name = 'ADifferentName'

Ex. Delete Query

DELETE OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles WHERE name = ''NewTitle''')