title: Difference between Select Into and Insert Into from old table?
body: <p>What is difference between these in terms of <strong>constraints</strong> *<em>keys</em>* etc.</p>
  
  <p>Select Into Statement </p>
  
  <pre><code>SELECT column1, column2, someInt, someVarChar 
  INTO ItemBack1 
  FROM table2
  WHERE table2.ID = 7
  </code></pre>
  
  <p>Insert Into Statement </p>
  
  <pre><code>INSERT INTO table1 ( column1, column2, someInt, someVarChar )
  SELECT  table2.column1, table2.column2,
  FROM    table2
  WHERE   table2.ID = 7
  </code></pre>
  
  <p>and also </p>
  
  <p><code>Create table ramm as select * from rammayan</code></p>
  
  <p><strong>Edit 1:</strong> </p>
  
  <p>Database SQL Server 2008</p>