how to get return value from stored procedure in sql
  • how can we get return value from stored procedure 
    for example if i have store procedure like this

    create procedure GetMaxNumber


    select 23

    so how can i get 23 in variable on out side where i execute this procedure.
  • 1 Comment sorted by
  • according to your requirement you can use 

    DECLARE @returnvalue int;
    @returnvalue =EXEC  GetMaxNumber

Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook


Popular Posts of the Week