Asynchronous sqlserver
how can i use Asynchronous queries in开发者_如何学Python sqlserver 2005 & asp (not .net)
ADO connection and recordset support asynchronous behavior, (look at this and this), however if your query returns data to the client, it may not make sense to use async behavior. You should consider using AJAX on the HTML side to launch queries and poll for results.
You have a good solution for SQL Server asynchronous queries documented with examples, use cases, etc., here:
https://www.cesarzea.com/czAsyncSQLServer
With that solution, that is an asynchronous call:
EXEC st_czAsyncExecInvoke
@sentence = 'exec st_proc1 123'
It lets you more complex calls. Go to the link to see more cases.
精彩评论