How to return value from stored procedure

Posted Date: 02 Jun 2004	Resource Type: Articles	Category: Databases
Author: Puneet	Member Level: Silver
Rating:	Points: 3


CREATE PROC TestReturn (@InValue int)
AS
Return @Invalue*2
go

CREATE PROC TestReturn1 (@InValue int)
AS
EXEC @InValue = TestReturn @InValue
Return @InValue

Declare @ReturnValue int
EXEC @ReturnValue = TestReturn1 6
Select ReturnValue=@ReturnValue

Responses

Author: Vineeth Ravikumar 03 Jan 2005 Member Level: Bronze Points : 0

I was Looking for Such a Thing...Thank you for your Help

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Tips for writing efficient "Join" statements
	Previous Resource: How to replace cursors with a trick:)?
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

More Resources