title: Passing default values to a column in Bulk insert
body: <p>I am trying to get data from a csv file with the following data.</p>
  
  <pre><code>Station code;Priority vehicle;DateBegin;DateEnd
  01;y;20100214;20100214
  02;n;20100214;20100214
  03;;20100214;20100214
  </code></pre>
  
  <p>Now I want a value 'n' in the table when no data is provided for the column 'Priority vehicle' in csv file.
  I am writing the query as </p>
  
  <pre><code>BULK INSERT dbo.#tmp_station_details  
      FROM 'C:\station.csv'  
      WITH (  
           FIELDTERMINATOR ='';'',  
           FIRSTROW = 2,
           ROWTERMINATOR = ''\n'' 
          )  
  </code></pre>