title: Insert a empty string on SQL Server with BULK INSERT
body: <p>Example table contains the fields <code>Id</code> (the Identity of the table, an integer); <code>Name</code> (a simple attribute that allows null values, it's a string)</p>
  
  <p>I'm trying a CSV that contains this:</p>
  
  <blockquote>
    <p>1,</p>
    
    <p>1,""</p>
    
    <p>1,''</p>
  </blockquote>
  
  <p>None of them gives me a empty string as the result of the bulk insertion. I'm using SQL Server 2012.</p>
  
  <p>What can I do?</p>