select * FROM openquery (ORACLE, 'select SFAB002 FROM DSDATA.VIEW_MO WHERE SFAADOCNO = ''A05-30D-2007000632''' ) --- 下面是一个很好的example,可以直接拿来用。我也经常把它当一个template。 DECLARE@SqlVARCHAR(1000) DECLARE@organizationIDVARCHAR(10) SELECT@organizationID= (SELECT ORGANIZATION_...
UPDATE OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles WHERE id = 101') SET name = 'ADifferentName'; B. Executing an INSERT pass-through query The following example uses a pass-through INSERT query against the linked server created in example A. Copy INSERT OPENQUERY (OracleSvr, 'SELE...
INSERTOPENQUERY (OracleSvr,'SELECT name FROM joe.titles')VALUES('NewTitle'); C. 執行 DELETE 傳遞查詢 下列範例會使用DELETE傳遞查詢來刪除範例 B 中插入的資料列。 SQL DELETEOPENQUERY (OracleSvr,'SELECT name FROM joe.titles WHERE name = ''NewTitle'''); ...
The following example uses a pass-throughINSERTquery against the linked server created in example A. Copy INSERT OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles') VALUES ('NewTitle'); D. Executing a DELETE pass-through query The following example uses a pass-throughDELETEquery to delete th...
OPENQUERY ( linked_server ,'query' ) UPDATE OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles WHERE id = 101') SET name = 'ADifferentName'; INSERT OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles') VALUES ('NewTitle'); DELETE OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles WHERE...
I am working on a project where I need to update Oracle Tables via a linked server on SQL Server. I must use OpenQuery and I need that query to be parameterized. Based on this, it is my understanding that I need to build my statement and execute it. ...
SQL Kopiér UPDATE OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles WHERE id = 101') SET name = 'ADifferentName'; B. Executing an INSERT pass-through queryThe following example uses a pass-through INSERT query against the linked server created in example A.SQL Kopiér ...
SQL Kopírovať UPDATE OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles WHERE id = 101') SET name = 'ADifferentName'; B. Executing an INSERT pass-through queryThe following example uses a pass-through INSERT query against the linked server created in example A.SQL Kopírovať ...
UPDATEOPENQUERY (OracleSvr,'SELECT name FROM joe.titles WHERE id = 101')SETname='ADifferentName'; B. Executing an INSERT pass-through query The following example uses a pass-throughINSERTquery against the linked server created in example A. ...
UPDATE OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles WHERE id = 101') SET name = 'ADifferentName'; B. Executing an INSERT pass-through query The following example uses a pass-through INSERT query against the linked server created in example A. SQL Copy INSERT OPENQUERY (OracleSvr,...