Results 1 to 3 of 3

Thread: Stored proc

  1. #1
    Ivan Guest

    Stored proc


    Can I call a sp from within a sp ?
    Is this a fairly normal practice ?

    Thanks,
    Ivan

  2. #2
    Karl Guest

    Stored proc (reply)

    Yes you can. Just type:

    EXEC ProcedureName Param1,Param2,......,ParamN

    It's pretty normal practice.

    Regards,

    Karl


    ------------
    Ivan at 5/9/01 8:34:39 AM


    Can I call a sp from within a sp ?
    Is this a fairly normal practice ?

    Thanks,
    Ivan

  3. #3
    MAK Guest

    Stored proc (reply)

    yes. Make sure that it wont do an infinite loop.

    -MAK

    ------------
    Ivan at 5/9/01 8:34:39 AM


    Can I call a sp from within a sp ?
    Is this a fairly normal practice ?

    Thanks,
    Ivan

Posting Permissions

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