Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002

    Unanswered: Flow Control in stored procedures

    A newbie question..

    If within a stored procedure there are a list of Stored Procedure calls.

    Create Procedure spTest AS

    EXEC spMyActionQuery1
    EXEC spMyActionQuery2
    EXEC spMyActionQuery3
    EXEC spMyActionQuery4


    Assuming each sub stored procedure executes an action query, does SQL Server ALWAYS wait for the current procedure to finish execution before proceding with the next stored procedure? I believe the answer is yes.

  2. #2
    Join Date
    May 2003
    Athens Greece
    The answer IS yes

Posting Permissions

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