Tuesday, September 7, 2010

How can optimize a Stored Procedure?

when used in stored procedure , the RETURN statement can specify an integer value to procedure. If no value is specified on RETURN , a stored procedure returns 0 , The stored procedure returns a value 0 when no errors were encountered . Any non-zero value indicates as error occured.

No comments:

Post a Comment