Tried searching and have not found the answer to this one. Think I know from testing but want to be sure.
I have a SP on MSSQL 2000 that I created. Within the table I call 6 update statements. All my params are input.
I developing software using VS 2008 PRO with a typed dataset. I added the stored procedure to my tableadapter and it created the subsequent update() method with an int return type.
I coded a statement to test the return value like so...
int Success = tableadapter.update(value1,value2,etc)
I examined the Success variable and found it to be 6.
I looked at another SP that calls 7 update statements within it and the return value after being called was 7.
I did not specify any return value in my SP. I can only presume that the SP is by default returning the aggregate amount of rows affected. My question is if my presumption is correct.
My reason for asking is I would like to know this value is reliable for testing that all 6 update statements in the SP were successful.
View Complete Post