title: What does value returned from 'IDbCommand.ExecuteNonQuery' represent?
body: <p>I am using ADO.net to call stored procedures to perform insertions into a Sybase database, and I want to include unit tests to ensure that the insert calls are working correctly.</p>
  
  <p>According to the spec:</p>
  
  <pre><code>IDbCommand.ExecuteNonQuery()
  </code></pre>
  
  <blockquote>
    <p>Returns: The number of rows affected.</p>
  </blockquote>
  
  <p>As each stored procedure is inserting one row, I am checking that the value returned == 1.
  However, each procedure returns a different value, ranging from 3 to 8. </p>
  
  <p>So, what exactly does the phrase 'The number of rows affected' mean?</p>
  
  <p>I should sepcify that the only statements in the procs are Set, Insert, Print and Return, and the only statement that doesn't seem to affect the return value is Insert!</p>
  
  <p>Thanks.</p>