drop procedure test1
gocreate procedure test1(@a varchar(20),@output int output)
as
declare @re int
if @a='1'
select @re=1
else
select @re=0
select @output=@rereturngodeclare @temp int
exec test1 '2',@temp output
select @TEMP
gocreate procedure test1(@a varchar(20),@output int output)
as
declare @re int
if @a='1'
select @re=1
else
select @re=0
select @output=@rereturngodeclare @temp int
exec test1 '2',@temp output
select @TEMP
go