A stored procedure contains a view which is accessed multiple times with the confines of the SP.
If the SP is executed multiple times in one query window with different parameters, e.g.
EXEC spMySP 1, 2, 3 GO EXEC spMySP 4, 5, 6 GO
- If one assumes that the first call will complete execution before the second one starts and therefore the view within the SP, will it be bound by the connection, session and process?
- If we were to place each SP execution in its own query window and execute the all, roughly at the same time - we assume they would execute asynchronously?
- Can we assume that the view would within the SP be operating within a new instance (More a theoretical question)?