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 - 2007-01-18 : 08:36:53
|
| Sudhan writes "HiI am using MS SQL 2000 server. I want a parameterised query for pagination support. I want to fetch a records in following order 1-100 then 100-200 , 200- 300 & so oni.e just want to fetch 100 records only per requestSelect * from table limit 100,200 above syntax is not workingHow can i do it with MS SQL 2000 server? any suggesions?Thanks in advance..." |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-18 : 11:28:44
|
| http://weblogs.sqlteam.com/jeffs/archive/2004/03/22/1085.aspx |
 |
|
|
|
|
|
How to implement Pagination on MS SQL 2000 server DB