Output parameter in Stored Prodedure

[5679]

I need to write a stored procedure with two output parameters. Please give me an example or an idea.

 

[tb]

Have you searched in BOL ?

I typed in .. output parameters and got a whole load ..

CREATE PROCEDURE myProc
@inparam int,
@outparam int OUTPUT


I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[VintageWine]

You also need to specify OUTPUT when calling the stored procedure. e.g.

CREATE PROCEDURE myProc 
    @inparam int,
    @outparam1 int OUTPUT,
    @outparam2 int OUTPUT
AS
SELECT @outparam1=49*@inparam

SELECT @outparam2=49*@outparam2

Calling script/procedure

DECLARE @q1 integer, @q2 integer

SELECT @q2=4

EXECUTE myProc 100, @q1 OUTPUT, @q2 OUTPUT

SELECT @q1, @q2

Above returns a single row:

4900 196

Have fun
Simon