Post permalink

• blowdart Peek-a-boo
  Aug 25, 2005 at 12:44 PM

  W3bbo wrote:

  Mike Dimmick wrote:SET ROWCOUNT 10 will limit the number of rows SQL Server returns to 10. To turn it off, SET ROWCOUNT 0.

  
  
  Ah yes, but how can you use it to implement paging?
  

  
  
  Well you could
  
  set rowcount pageNumber * pageSize
  select into #tempKey
    keyField from table order by keyField
  set rowcount pageSize
  select * from table where keyID not in (select keyField from #tempKey) order by keyField
  
  Or something like that
  

See more posts in thread…