How to set value of procedure to variable?

• sasia14

  Valued Member

  Points: 56

  More actions

  September 8, 2013 at 6:56 am

  #298634

  Hello mates.

  I want to create a procedure with follow two sentences.

  DECLARE @Wallet int

  SET @Wallet = EXEC HowMoneyIsInTheWallet @IDOsoby

  And I have this error: Incorrect syntax near the keyword 'EXEC'.

  How resolve the problem ?

• SrcName

  Default port

  Points: 1460

  More actions

  September 8, 2013 at 10:17 am

  #1648391

  Hi sasia

  you need to define output parameter to your procedure

  for example

  create procedure HowMoneyIsInTheWallet

  (

  @IDOsoby int,

  @Wallet int OUTPUT

  )

  AS

  -- your code where you set value to @Wallet

  return @Wallet

  call the stored procedure

  DECLARE @WalletReturned int, @Wallet int

  EXEC @WalletReturned = HowMoneyIsInTheWallet @IDOsoby, @Wallet output

  print @WalletReturned

• sasia14

  Valued Member

  Points: 56

  More actions

  September 8, 2013 at 12:13 pm

  #1648397

  Thank you SrcName for your answer.

  You help me, and i am thankfull you for that 🙂

  I wish you have a nice day 😀

  Enjoy 🙂