Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2013-09-06 : 04:30:24
|
| If you're doing a simple UPDATE on a single table from a stored procedure what, if anything, do you return from the stored procedure and why?tiasteve-----------Insanity: doing the same thing over and over again and expecting different results. |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-09-06 : 05:04:10
|
| Most of the developers will return "Number of rows processed" parameter as output... Because in the case of Success it returns the number(How many rows affected for the UPDATE statement); Otherwise return ERROR code from the catch block....--Chandu |
 |
|
|
|
|
|
Conventions