var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: fetching result set batch at a time
if i have a sql select statement which results in 300K rows, is there a mechanism to fetch it say 10K at a time?
Maybe, depending on what you mean and how you intend to accomplish it. Your question isn't specific enough for me to give you a more specific answer than that.
oh, come on, pat, you're being stubborn
he's talking about paging, paging, paging, paging, or paging
just about everybody and his brother has written about paging in sql server
thanks guys, i had the concept in mind but didn't know the term... i'll take it from here do some googling :-)
sorry didn't realize those were links too extra thanks
If you read pages with 10K rows, you have WAY too much time on your hands! I hope to high heaven that g11DB has something very different on their mind, although I can see how the concepts are similar.
yea that's probably too high a number for my example i'd say in the real world it shouldve been somewhere between 10 and 50
My brother has certainly never written about paging. He wouldn't know an SQL statement if it selected him in the face.
Originally Posted by r937