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.
   

   skdmail, May 27, 2008

   #2
2. FrankKalis Moderator

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

   FrankKalis, May 27, 2008

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in