title: Openquery select into VS insert into (SQL Server 2016) Issue
body: <p>I have the following SQL code to dynamically populate data into the tables but I now need to insert only. I am aware that select into also created the tables whereas insert simply populates existing tables. </p>
  
  <p>Here is the SELECT INTO:</p>
  
  <pre><code>SET @SQL = 'Select * into destinationdb.stage.'+@Name + ' from    openquery("LINKEDSERVER", ' + '''SELECT * FROM source_db.' + @Name + ''');'
  </code></pre>
  
  <p>And  here is the INSERT INTO that I tried.</p>
  
  <pre><code>SET @SQL='insert into destinationdb.stage.'+@Name + ' * from  openquery("LINKEDSERVER", ' + '''SELECT * FROM source_db.' + @Name + ''');'
  </code></pre>
  
  <p>Which is of course gave me syntax errors. </p>
  
  <p>I have tried many similar variations and am wondering if someone can spot my syntax error in the INSERT INTO?</p>