title: How to UPDATE all columns of a record without having to list every column
body: <p>I'm trying to figure out a way to update a record without having to list every column name that needs to be updated.</p>
  <p>For instance, it would be nice if I could use something similar to the following:</p>
  <pre><code>// the parts inside braces are what I am trying to figure out
  UPDATE Employee
  SET {all columns, without listing each of them} 
  WITH {this record with id of '111' from other table}
  WHERE employee_id = '100'
  </code></pre>
  <p>If this can be done, what would be the most straightforward/efficient way of writing such a query?</p>