Stored Procedure Interview Question:

Explain about the RETURN statement?

Submitted by: Administrator

A RETURN statement is used to terminate the execution of a stored function. This inturn returns a value of expr to the function caller. In a stored function there should be at least a single return statement. If there exists multiple functions it can have multiple exit points.
Submitted by: Administrator