title: How do I insert data in specific columns in SQL Server 2012?
body: <p>I am using the AdventureWorks2012 database...
  I created a backup table using the SELECT INTO clause. However, I got an error message when I tried to insert data into some columns using the query below:</p>
  
  <pre><code>INSERT   INTO  Sales.salesorderdetails_backup     
                                        (SalesOrderID , 
                                         OrderQty,     
                                         ProductId,   
                                         SpecialOfferId,  
                                         UnitPrice,    
                                         UnitPriceDiscount,    
                                         LineTotal)
                                         OUTPUT  inserted.*
                  VALUES (57123,
                           45,
                           712,
                             1,
                          15.89,
                              0,
                           45.89)
  </code></pre>
  
  <p>I got the error msg: </p>
  
  <blockquote>
    <p>Cannot insert the value NULL into column 'rowguid', table
    'AdventureWorks2014.Sales.salesorderdetails_backup'; column does not
    allow nulls. INSERT fails...</p>
  </blockquote>