SQL Server Performance

Synchronous or Asynchronous?

Discussion in 'General Developer Questions' started by skdmail, May 27, 2008.

  1. skdmail New Member

    If i am executing a stored procedure mysp_Main like the one below:
    CREATE PROCEDURE mysp_Main
    AS
    EXEC mysp_Proc1
    EXEC mysp_Proc2
    Go
    Will the execution of mysp_Proc2 start after mysp_Proc1 is complete or once called, the procedure will proceed with the next statement whether the first proc is complete or not.
  2. FrankKalis Moderator

    SQL is synchronous. The second procedure will not start before the first is completed.

Share This Page