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
spfoo
is 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