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 |
|
rexselin
Starting Member
1 Post |
 Posted - 2005-07-28 : 03:22:59
|
| Hi,I am a newbie in transact sql and I would like to know how to implement the mutiple paging feature using transact-sql. Say I have a query, that would retrieve 100 records and I want to display 10 records per page.In mysql, I would usually give,select * from mytable limit 0,10where 0 is the position of the start of the record and 10 is the number of records I would like to retreive.Is this possible? or should I get the entire recordset and then implement the logic in my front end script?Regards,Celia |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Limiting the number of records in a query