Prev: function or View
Next: How to find out what rows successfuly/failed to insert
From: Andy B. on 25 Mar 2010 05:44
What's the best way to return error or status codes when you also return a
resultset?


From: Uri Dimant on 25 Mar 2010 07:17
Andy
If you identify an error just use RETURN command with 1 or -1 to indicate
the error, so no need to return result set, right?

Otherwise
SELECT 1 AS errorcode, <columns> FROM tbl
WHERE...............



"Andy B." <a_borka(a)sbcglobal.net> wrote in message
news:ejFq5%23$yKHA.6140(a)TK2MSFTNGP05.phx.gbl...
> What's the best way to return error or status codes when you also return a
> resultset?
>


 | 
Pages: 1
Prev: function or View
Next: How to find out what rows successfuly/failed to insert