title: Bulk insert in SQL Server database from one table to another
body: <p>I have 200k records in one table and I want to insert these records into another table. I read about the bulk insert but the query I found on msdn website is just not making any sense. </p>
  
  <p>This is the query</p>
  
  <pre><code> BULK INSERT AdventureWorks2012.Sales.SalesOrderDetail
   FROM 'f:\orders\lineitem.tbl'
   WITH 
    (
       FIELDTERMINATOR =' |',
       ROWTERMINATOR =' |\n'
    );
  </code></pre>
  
  <p>What is <code>f:\orders\lineitem.tbl</code> and the whole this is just not making any sense.</p>
  
  <p>I have a table with four columns: id, frm, to1 and country</p>
  
  <p>Same this in destination table</p>
  
  <p>Any easy syntax will be helpful</p>
  
  <p>I am using SQL Server 2008/12</p>