title: OPENQUERY update on linked server
body: <p>I want to execute the following statement through from a linked server (openquery):</p>
  
  <pre><code>UPDATE SAP_PLANT 
  SET (OWNER, OWNER_COUNTRY) = (SELECT import.AFNAME, import.COUNTRY
                                  FROM SAP_IMPORT_CUSTOMERS import, SAP_PLANT plant
                                  WHERE plant.SAP_FL = import.SAP_NO
                                  AND import.role ='OWNER')
  </code></pre>
  
  <p>I've tried to form it into the following syntax, without success :(</p>
  
  <pre><code>update openquery(‘my_linked_server, ‘select column_1, column_2 from table_schema.table_name where pk = pk_value’)
  set column_1 = ‘my_value1′, column_2 = ‘my_value2′
  </code></pre>
  
  <p>I hope for you this is no problem?</p>