Decalre number of resultset that the SQL procedure returns of Create Procedure statement using RESULT SET n, where n is the number of result sets.
Declare cursor CURSOR WITH RETURN FOR
Exit from Procedure without closing cursor
Originally posted by toby25
How do I return resultset from Stored Procedure to the application?