Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Tue, 26 Apr 2005 20:00:34 -0500
>so... here I have a stored procedure...
>
>CREATE PROCEDURE dbo.getPayments @meetingCode char(6), @guestid char(10) AS
>return (select sum(a.amount) as payments from dbo.payments a
>where (A.meetingCode= @meetingCode) and (a.guestid = @guestid)
>group by a.guestid
>)
>GO
The parameter is @Return_value and don't create your parameters
just call Parameters.refresh
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- Follow-Ups:
- References:
- Prev by Date: Re: Editing a view
- Next by Date: Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
- Previous by thread: Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
- Next by thread: Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
- Index(es):
Relevant Pages
|
