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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-15 : 08:22:53
|
| asql_guy writes "I have a table in SQL server 7.0 DB with around 35,000 records.I need to provide the pagination option to the user such that he can choose recrods 1- 10 , 11-20 , 21-30 and so on..Can you pl let me know how we can acheive this with SQL server 7.0.Thanks.." |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-15 : 10:22:23
|
| Do you have an identity column?SELECT *& FROM myTable WHERE identColumn BETWEEN @start AND @EndDoesn't taki in to account any gaps in th esequence I'm afraid.Brett8-) |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-07-15 : 10:26:38
|
| jsmith has written an article on this issue; it's the best treatment of the problem i've seen to date. search for it on this site.Jonathan{0} |
|
|
|
|
|
|
Pagination in SQL server 7.0