Return more than one value from procedure.

rashid · Post by **rashid** » Wed 11 May 2005 06:41

i can do it with 1 value;
in store procedure: REturn 1
in delphi;
execute;
returningvalue := Parambyname('REturnvalue').AsInteger;

but how do i return more than 1 value from a stored procedure?

Ikar · Post by **Ikar** » Wed 11 May 2005 14:26

Use follow syntax

CREATE PROCEDURE ALL_TYPES_IO
@c_int int = 0 OUTPUT ,
@c_bigint bigint = 0 OUTPUT
AS
SELECT @c_int = 111

See MSDN for details

rashid · Post by **rashid** » Thu 12 May 2005 09:16

Thanks. It is working as expected.
rashid