February 27, 2007 at 12:52 pm
Hi, All
Hope anyone could give me some ideas or express your opinion about the following:
While running some stored procedures I'm getting partial results of my query and on the bar status it keep saying "executing query", so in other words it takes a couple of minutes to run, but it keep returning rows constantly.
I was under the impresion that stored procedures returns all the rows, only when it gathers all of them and then flush them to the screen.
Please let me know your comments.
Thanks.
February 27, 2007 at 1:19 pm
If you're just performing selects ... from ... without saving the results to variables or into another table, you sp will return it as a rowset.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply