title: SQL Server : copy the whole column to another column error
body: <p>I am trying to move all the data from <code>fælge</code> column in the test table into the <code>fælgen</code> column in table test to with this query</p>
  
  <pre><code> INSERT INTO [dbo].[test2] ([Fælgen])
       SELECT Fælge 
       FROM [dbo].[test]; 
  </code></pre>
  
  <p>but I am getting a error with it saying that it cant insert the null into column ET which is not that column i am trying to insert my data to</p>
  
  <blockquote>
    <p>Msg 515, Level 16, State 2, Line 2<br>
    Cannot insert the value NULL into column 'ET', table 'OminiData.dbo.test2'; column does not allow nulls. INSERT fails.</p>
  </blockquote>