Stored procedure with output variable

[JC]

Can someone post a working stored procedure with output variable that
works on northwind db or explain to me what I am missing. I've tried
ever tying but it always returns @outvariable parameter not supplied.
I've read everything but must be missing something. Here is an sample
SP that I can't get to work.
_____________________________________

CREATE PROCEDURE SampleProcedure
@out smallint OUTPUT
AS
Select @out = count(*) from titles
GO
_____________________________________
This errors and returns-
Server: Msg 201, Level 16, State 4, Procedure SampleProcedure, Line 0
Procedure 'SampleProcedure' expects parameter '@out', which was not
supplied.
What am I missing with this?
Frustrated,
Jeff

[John Bell]

Hi

Try:

DECLARE @outvariable smallint
EXEC SampleProcedure @outvariable OUTPUT
PRINT @outvariable

John
"JC" <uj*****@charter.net> wrote in message
news:b8**************************@posting.google.c om...

Can someone post a working stored procedure with output variable that
works on northwind db or explain to me what I am missing. I've tried
ever tying but it always returns @outvariable parameter not supplied.
I've read everything but must be missing something. Here is an sample
SP that I can't get to work.
_____________________________________

CREATE PROCEDURE SampleProcedure
@out smallint OUTPUT
AS
Select @out = count(*) from titles
GO
_____________________________________
This errors and returns-
Server: Msg 201, Level 16, State 4, Procedure SampleProcedure, Line 0
Procedure 'SampleProcedure' expects parameter '@out', which was not
supplied.
What am I missing with this?
Frustrated,
Jeff

[JC]

Thank you John, worked as I've been expecting.
Jeff

"John Bell" <jb************@hotmail.com> wrote in message news:<LN*******************@news-text.cableinet.net>...

Hi

Try:

DECLARE @outvariable smallint
EXEC SampleProcedure @outvariable OUTPUT
PRINT @outvariable

John
"JC" <uj*****@charter.net> wrote in message
news:b8**************************@posting.google.c om...

Can someone post a working stored procedure with output variable that
works on northwind db or explain to me what I am missing. I've tried
ever tying but it always returns @outvariable parameter not supplied.
I've read everything but must be missing something. Here is an sample
SP that I can't get to work.
_____________________________________

CREATE PROCEDURE SampleProcedure
@out smallint OUTPUT
AS
Select @out = count(*) from titles
GO
_____________________________________
This errors and returns-
Server: Msg 201, Level 16, State 4, Procedure SampleProcedure, Line 0
Procedure 'SampleProcedure' expects parameter '@out', which was not
supplied.
What am I missing with this?
Frustrated,
Jeff