Sometimes you end up with a return value of -1 when using the SqlClient.SqlCommand.ExecuteNonQuery method. Why is that? Well, the ExecuteNonQuery method is there for statements for changing data, ie. DELETE / UPDATE /INSERT, and the returned value are