除非调另一个存储过程的输入参数,要调内部的变量可能不行。
create procedure test1 @a int output
as
set @a = 1
gocreate procedure test2
as
declare @i int
exec test1 @i output
select @i
create procedure test1 @a int output
as
set @a = 1
gocreate procedure test2
as
declare @i int
exec test1 @i output
select @i
@a int output
as
set @a=2
gocreate proc yy
as
declare @t int
exec xx @t outputselect @t
go