output value

Results 1 to 2 of 2

Thread: output value

  1. #1
    Join Date
    Dec 1969

    Default output value

    Hi-<BR><BR>I&#039;m creating a procedure that executes 2 other stored procedures within it. <BR><BR>The first procedure is encrypted, so I can&#039;t see what&#039;s going on, but it does return a value that I need to execute the 2nd stored procedure. <BR><BR>How do I get the value from the 1st proc and pass it to the 2nd?<BR><BR>Thx.

  2. #2
    Join Date
    Dec 1969

    Default RE: output value

    *<BR>If it&#039;s a return value,<BR>EXEC @variable_name = sp_SomeProcedure param1, param2...<BR><BR>if it&#039;s an output parameter,<BR>sp_SomeProcedure param1, param2, @variable_name OUT<BR><BR>hope this helps..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts