Stored procedure executing another stored procedure

Question

When a Stored Procedure has a query inside to execute another Stored Procedure, does the calling Stored Procedure stop other Stored Procedure has finished executing? I guess I'm trying to get straight in my head whether it's like synchronous and asynchronous calls.

Answer 1

Yes, it's synchronous

Answer 2

Yes they are synchronous. They would have to be. If stored procedure A is expecting a result from stored procedure B, then it would have to wait for Stored Procedure B to finish. The implications would be huge if they were automatically asynchronous.

For a follow up. Here is how to make stored procedures asynchronous in MSSQL Server (well as asynchronous as possible):

http://stackoverflow.com/questions/25460/asynchronous-stored-procedure-calls