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 

for reference


Comments

Popular posts from this blog

angularjs - ADAL JS Angular- WebAPI add a new role claim to the token -

php - CakePHP HttpSockets send array of paramms -

node.js - Using Node without global install -