1

how can i use Asynchronous queries in sqlserver 2005 & asp (not .net)

Improve this question
2
  • Please support your question with example or any case. Commented Jul 6, 2015 at 5:18
  • Can you tell your exact issue. As this is not possible to call Sql Server query Async. You can't call and take response more than one from sql server to your c# code. Better way is to go with ajax jquery. It will solve your problem. If you will share your issue, we can help you more accurate. Commented May 21, 2018 at 14:09

2 Answers 2

Reset to default
1

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

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.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.