title: Insert into table on the Linked Server with data from local table
body: <p>I'm working with SQL Server Express, I created a linked server to an Oracle database. </p>
  
  <p>As the title indicates, I want to insert data selected from a local table into a table at the Linked Server.</p>
  
  <p>I tried many queries but no one of them worked as I want.</p>
  
  <p>This query below I used has worked, but only with static values, but I want to insert data dynamically from the a table on local database.</p>
  
  <pre><code>INSERT OPENQUERY (ORTEST, 'SELECT * FROM reservation')
  VALUES (2, '2', 3);
  </code></pre>