If I put 5 or 6 stored procedures within another stored procedure will they be executed sequentially or all at once? Is there any method. I can manage this process with some code I was just wondering how query analyzer or an sp would handle this by default.
The sprocs will run asynchronously, or as I said, sequentially.
No, Brett got it right.
When working asynchronously, each process gets their own thread and stuff happens simultaneously.
Synchronously, all processes share the same thread and therefore can not run simultaneously. One process needs to end before the next one can start.
seems to be some confusion on what sync and async mean.
In programming, an async method generally launches a separate thread to do a long-running task and then returns immediately. a sync method does the work on the thread that called it, so it doesn't return until the work is done.
there is no way to spawn threads from a proc (unless it's a CLR proc) so all procs are synchronous in this sense.