Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2002
    Location
    New Jersey
    Posts
    39

    Unanswered: Stored Procedure - multiple output paramters

    Is it possible to return multiple output parameters from a stored procedure?

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Yes.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Feb 2002
    Location
    New Jersey
    Posts
    39
    Originally posted by Paul Young
    Yes.
    Got an example?

  4. #4
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    sure:

    create procedure #phppete (
    @p1 int output
    , @p2 char(1) output)
    as
    select @p1 = 2
    , @p2 = 'B'
    return 0
    go

    declare @p1 int, @p2 char(1)
    select @p1 = 1
    , @p2 = 'A'

    exec #phppete @p1, @p2
    select @p1, @p2

    exec #phppete @p1 output, @p2 output
    select @p1, @p2
    go
    Paul Young
    (Knowledge is power! Get some!)

  5. #5
    Join Date
    Feb 2002
    Location
    New Jersey
    Posts
    39
    Thanks,

    I'll give that a try.

    Regards,

    PAS

  6. #6
    Join Date
    Dec 2004
    Posts
    6
    Somebody please show me how to do this in esql/c !!??

    Cheers,

    AllanK

Posting Permissions

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