title: Bulk insert of multiple files in SQL Server
body: <p>I have several chunks of a table in .dat files</p>
  
  <p>I want to import all of these chuncks to a single sql server table.</p>
  
  <p>To do it with one I do</p>
  
  <pre><code>BULK INSERT dbo.Tab
  FROM 'C:\Data\1.dat'
  WITH
    (
      FIELDTERMINATOR = ',',
      ROWTERMINATOR = '\n'
    );
  </code></pre>
  
  <p>but how to append to the table the rest of the .dat files?</p>