title: MSSQL - How to set default value in BULK INSERT?
body: <p>I am trying to get data from a csv file with the following data.</p>
  
  <pre><code>Employee Name: Employee Id : Employee Type : Joining Date 
  Henry   : 000123   : Permanent   : 01/01/2011  
  Mathew  : 111524   : Contract    : 05/04/2011  
  Steven  : 002544   : Permanent   : 07/12/2010  
  Sophia  : 015474   :             : 29/02/2011
  Rooney  : 111303   :             : 11/11/2010
  </code></pre>
  
  <p>Now I want to set </p>
  
  <p>I have 2 cvs file and 2 format file where 1 for permanent type and 1 for contract type. Now I want to set the value in the table when no data provided. For an example, column 'Employee Type'. How do i set an default value where when i run the permanent employee cvs the 'Employee Type = Permanent' and when I run contract cvs 'Employee Type = Contract'.</p>
  
  <pre><code>BULK INSERT Employee_Table
      FROM 'C:\Employee.csv'  
      WITH (  
           FIELDTERMINATOR ='';'',  
           FIRSTROW = 2,
           ROWTERMINATOR = ''\n'' 
          )  
  </code></pre>