Stored procedure executing another stored procedure
sql, sql-server, stored-procedures
Solution
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
Problem
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.