Returning a Result Set from a Stored Procedure

You can use the RETURNS option to return a result set, in the form of a temporary table, from a stored procedure. This temporary table can only be inserted into. It cannot be referenced, from inside the stored procedure, using a SQL SELECTUPDATE or DELETE statement.

Examples