Stored procedure executing another stored procedure

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 sy开发者_JAVA百科nchronous and asynchronous calls.

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):

Asynchronous Stored Procedure Calls

Yes, it's synchronous