Friday, February 24, 2012

Couple of Simple questions

I know that it is good practice to use NO COUNT and RETURN in a stored
procedure but what does that do for the stored proc? I cannot seem to find a
solid answer on this except its good practice.
thanks in advance
robRob,
Read this:
http://www.sql-server-performance.c..._procedures.asp
HTH
Jerry
"Rob" <temp@.dstek.com> wrote in message
news:ukfTz%23FyFHA.720@.TK2MSFTNGP15.phx.gbl...
>I know that it is good practice to use NO COUNT and RETURN in a stored
> procedure but what does that do for the stored proc? I cannot seem to find
> a
> solid answer on this except its good practice.
>
> thanks in advance
> rob
>

No comments:

Post a Comment