T-SQL CRUD operations for Linked Server using OPENQUERY

La tradition de la gagne commence sur win vegas plus, votre destination privilégiée pour des jackpots explosifs. Recevez des récompenses exclusives et prolongez votre temps de jeu dans une ambiance digne des plus grands casinos.

This is a modified version of the original post found here. Below is the standard operations (SELECT, INSERT, UPDATE & DELETE) used in T-SQL backend operations.

SQL Queries tested on Microsoft SQL 2008 R2

SELECT Statement

-- W/o Parameter(s)

SELECT * FROM OPENQUERY (OracleSvr, 'SELECT name FROM JOBS');

-- W/ Parameter(s)

DECLARE @name nvarchar(max) = 'John'; 
SELECT * FROM OPENQUERY (OracleSvr, 'SELECT name FROM JOBS WHERE name = '' + @name + '' ');

INSERT Statement

INSERT OPENQUERY (OracleSvr, 'SELECT * FROM JOBS')  
VALUES 
(
'John'       -- First Name
,'Doe'       -- Last Name
,'Mortician' -- Title
,'INACTIVE'  -- Status
);  

UPDATE Statement

SELECT * FROM OPENQUERY (OracleSvr, 'SELECT * FROM JOBS WHERE Title = ''Mortician''')
SET Title = 'Grave Digger'

Delete Statement

DELETE OPENQUERY (OracleSvr, 'SELECT * FROM JOBS WHERE Id = 1');