title: How to return result of Sql Server stored procedure to .Net
body: <p>What is the best way to return the result of the execution of a SQL Server stored procedure back to the .NET code?</p>
  
  <p>If I want to return the success or failure of a bunch of deletes in a transaction, should I 'Select' something, or maybe something like RETURN(1) or RETURN(0), or do I communicate number of rows affected?</p>
  
  <p>Then will this be the return value for ExecuteNonQuery()?</p>