Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Posts
    2

    Unhappy Unanswered: Nested execution of strored procedures

    How i can capture one nested stored procedure's ouput parameter and using the out param in calling stored procedure....Help me..

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    declare @i int
    exec sptest @i output

    create procedure sptest
    @i int output
    as
    ...


    For a dynamic sp call see
    www.nigelrivett.com
    setting variables from dynamic sql

Posting Permissions

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