title: SQL Server: How can I copy data from one table to another table without the characters 'e+' being added to the results
body: <p>I am copying data from a table created by an Excel spreadsheet import.</p>
  
  <p>Here is what I am doing to move the data from the import table to the actual table: </p>
  
  <pre><code>INSERT INTO TableName ([Column1], [Column2])
  SELECT [Column1], [Column2] FROM [Sheet1$] 
  </code></pre>
  
  <p>After I execute this under column 1 I get records like:</p>
  
  <p><code>5.31752e+007</code> when the actual value of that record (from the table I am importing from) is <code>5046610163</code></p>
  
  <p>Any ideas?</p>