title: sql server saves only null values for some columns
body: <p>I have a table with some nvarchar(max), varchar(100) and bit type columns.
  I am inserting values to it programmatically using <code>SQLCommand.ExecuteNonQuery().</code></p>
  
  <p>I am providing string values to all the nvarchar and varchar columns and 0 or 1 to bit column using <code>SQLParametr.AddWithValue("@parameterName", parameterValue)</code></p>
  
  <p>For some columns it is storing proper values but for some only null values are getting stored even after providing proper parameter values.
  Columns in which null values are stored are of type varchar(100) and bit.</p>
  
  <p>In development environment everything works fine, issue occurs in testing environment.</p>
  
  <pre><code>The insert query looks like "INSERT INTO SOME_TABLE(Col1,Col2,Col3,Col4) VAlues(@param1, @param2, @param3, @param4)"
  </code></pre>
  
  <p>Parameter values are proper even in testing environment tested the same by printing the values to a log file.</p>
  
  <p>Any explanation for this unusual behavior.</p>