Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Retrieving records

Author  Topic 

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2007-01-11 : 15:05:03
Gurus
i have 20 records in a table, i want to get rows from 11-15.
How will i do this?
Regards
Nitin

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-01-11 : 16:07:06
From http://sqlteam.com/forums/topic.asp?TOPIC_ID=77465#281265

quote:
http://www.google.com/search?hl=en&lr=&q=sql+server+2000+paging&btnG=Search

The solution that we use involves a temp table, but there are many solutions. So check out what Google returns and see what fits your needs. Also check out Jeff's paging in 2000 article.

Tara Kizer
Go to Top of Page
   

- Advertisement -