title: How to update one table from another one without specifying column names?
body: <p>I have two tables with identical structure and VERY LARGE number of fields (about 1000). I need to perform 2 operations 
  1) Insert from the second table all rows into the fist. Example:</p>
  
  <pre><code>INSERT INTO [1607348182]
  SELECT * 
  FROM _tmp_1607348182;
  </code></pre>
  
  <p>2) Update the first table from the second table 
  but for update i can't found proper sql syntax for update.</p>
  
  <p>Queries like:</p>
  
  <pre><code>Update [1607348182]
  set [1607348182].* = tmp.*
  from [1607348182]
  inner join _tmp_1607348182 as tmp on tmp.recordid = [1607348182].recordid
  </code></pre>
  
  <p>or </p>
  
  <pre><code>Update [1607348182]
  from [1607348182]
  inner join _tmp_1607348182 as tmp on tmp.recordid = [1607348182].recordid
  </code></pre>
  
  <p>are invalid.</p>