OPENQUERY for update.

Question

User779033375 posted

Hi All,

I need to update some data in Linked server.

query:

update table1 set column1='value' where conditioncolumn1 in ('1','2','3','4')

Here we need to user OPENQUERY

Is below query formation a correct procedure/syntax?

OPENQUERY

(

dbconnectionName,

'update table1 set column1='value' where conditioncolumn1 in ('1','2','3','4')'

)

Answer 1

User1724605321 posted

Hi saffy ,

Here we need to user OPENQUERY

Please refer to OPENQUERY (Transact-SQL) document , it executes the specified pass-through query on the specified linked server , the Syntax will be :

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

Remarks: OPENQUERY does not accept variables for its arguments. OPENQUERY cannot be used to execute extended stored procedures on a linked server .

In addition , you could also refer to below article for details about Linked Server:

https://msdn.microsoft.com/en-us/library/ms188279.aspx .

Best Regards,

Nan Yu

Answer 2

User779033375 posted

Thank you.