sql server - T-SQL Stored Procedure returned value into variable -
i have simple stored procedure on ms sql 2012 express returns result doing :
declare @value int; select @value; meanwhile trying call stored procedure doing like
declare @result int; exec @result = spfoo ..... however value on @result spfoois 0.
how can real value returned stored procedure?
thanks
first declare @value output parameter in called sp
create procedure spcallee @value int output begin set @value = 1 end go get result in caller sp
create procedure spcaller begin declare @result int = 0 exec spcallee @value = @result output select @result end go 
Comments
Post a Comment