title: How make an UPDATE/INSERT query on Linked Server?
body: <p>I have a linked server to which I have to update data or insert new data coming from my DB.
  So, I have to define a query in SQL in order to do that
  I already search on the net, but any solution I found work.
  Can somebody help me??</p>
  
  <p>Suppose that the name of my linkedServer is AAA and the table of linked server that I have to update is BBB, I tried with</p>
  
  <pre><code>UPDATE AAA.BBB AS I
  SET
     I.X = @MYVALUEX
     I.Y = @MYVALUEY
  WHERE
    ...
  </code></pre>
  
  <p>but it doesn't work.</p>
  
  <p>Thanks in advance for any suggestions,</p>
  
  <p>Deborah</p>