title: SqlCommandBuilder and SQL Server Computed Columns - Error
body: <p>What is the right way to avoid errors on INSERT and UPDATES with a SqlDataAdapter/SqlCommandbuilder when the SQL Statement used to SELECT has a computed column as one of the return fields?</p>
  
  <p>I get the error now that "The column <em>Amount</em> cannot be modified because it is either a computed column or is the result of a UNION operator".</p>
  
  <p><strong>UPDATE</strong>: 
  I fixed the issue by using a query like this:</p>
  
  <pre><code>SELECT *, PercentRating * 500 AS CoreValue FROM ValueListings
  </code></pre>
  
  <p>And ditching the computed column.
  Now it works. How is that SqlCommandBuilder realizes to <em>NOT</em> build the CoreValue field into the UPDATE and INSERT statements? Anybody know how this works internally?  </p>