How do I declare a procedure that returns a recordset?
539442Nov 20 2006 — edited Nov 20 2006I have to use a procedure that returns me a recordset.
On SQL server I would use
CREATE PROCEDURE proc_name
AS
BEGIN
select * from table
END
or
CREATE PROCEDURE proc_name
AS
BEGIN
DECLARE @temp TABLE (a,b,c,...)
INSERT INTO @temp
select * from @temp
END
Also, can I work with a temporary table as I used on MSSQL?