how can pass the output values of one procedure to other procedure

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Declare @MyParam as int

set @MyParam = 6

EXEC dbo.MySP1 @MyParam output

--let's say that MySP1 set the param to 8

EXEC dbo.MySP2 @MyParam

Jim Turner Newbie Points: 9 More actions · Answer 2

If it would make sense in your context, you could call one stored procedure from another.

Thus Procedure A calls Procedure B and then uses the output from Procedure B to do its work.

Within procedureA

Decalare @param as [datatype]

exec dbo.ProcedureB @param output

[do the work of ProcedureA using the value of @param]

5409045121009-7368 SSCoach Points: 15740 More actions · Answer 3

Create Procedure TestB (@Parameter1 Varchar(10),@Parameter2 Varchar(10) Output) as

Select 'Inside TestB @Parameter1 : ',@Parameter1,'@Parameter2 : ',@Parameter2

Select @Parameter2='1'

Return

go

Create Procedure TestA (@Parameter1 Varchar(10)) as

Declare @Parameter2 Varchar(10)

Select @Parameter2='1',@Parameter1='0'

Select 'TestA Before @Parameter2 : ',@Parameter2

Exec TestB @Parameter1,@Parameter2 Output

Select 'TestA After @Parameter2 : ',@Parameter2

Return

go

Exec TestA 'A'

Go

Drop procedure TestA

Drop Procedure TestB

Go