Essentially, I want to call the stored procedure (MS SQL) and then come back when it is ready to display the results in ASP.NET. Can MS SQL queue query results for retrieval at a later time? If so, is there a way to poll SQL to see if the results are ready?
2006-12-27 19:18:30 · 4 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
Go through the Connection and Result Set properties of MS-Sql Server.
You will find the solution.
2006-12-27 20:26:56 · answer #1 · answered by Anonymous · 0⤊ 0⤋
until the connection is not closed, you can still display the result of that Stored Procedure that you processed. It really depends on how you synchronize a certain process to produce a certain output.
I can't give much of a comment co'z i don't know how your code looks like....
-ciao!!!
2006-12-27 19:23:00 · answer #2 · answered by Bryan 2 · 0⤊ 0⤋
Which sq.? MSSQL, MySQL? additionally what programming language are you making use of to call the techniques? you're able to desire to furnish slightly extra information as all languages react very in yet in any different case in spite of possible the comparable
2016-11-24 19:30:13 · answer #3 · answered by ? 4 · 0⤊ 0⤋
well you can do that with cursors...
2006-12-27 19:22:17 · answer #4 · answered by sweetraskels 4 · 0⤊ 0⤋