Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 second store procedure take first one output

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2005-07-09 : 04:23:57
I created a two store procedures, sp1 and sp2. sp1 take a input parameter and then output a string as sp2 input parameter. Is it possible?

hgorijal
Constraint Violating Yak Guru

277 Posts

Posted - 2005-07-09 : 11:50:44
declare @string varchar(2000)
exec SP1 @parm=@string OUTPUT
Exec SP2 @parm=@string

but, If you are looking to do it in a single statement, then, no.

Hemanth Gorijala
I Came. I Saw. I Normalized.
Go to Top of Page
   

- Advertisement -