Passing Variables Between Stored Procedures

• Martin D. Cymerman

  SSCrazy

  Points: 2079

  More actions

  February 18, 2005 at 1:38 pm

  #85102

  Has anyone ever passed variables between stored procedures. I looked at BOL and so far I have not found anything of use.

  Thanks

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  February 18, 2005 at 1:49 pm

  #543170

  2 ways of doing this :

  1-

  create myproc2 @somevariable as int

  as

  select 1

  go

  Create myproc1

  as

  set @somevariable = 3

  exec myproc2 @somevariable

  go

  2-

  Create myproc1 @SomeVariable int output

  as

  set @somevariable = 3

  go

  create myproc2 @SomeVariable int

  as

  select 1

  go

  declare @var int

  exec myproc1 @var output

  exec myproc2 @var