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 |
|
javaisok
Starting Member
11 Posts |
 Posted - 2003-08-25 : 06:05:52
|
| Hi all,i have a table with 20 000 rows (article_id (PK), ...).lets assume each virtual page has 30 rows. Now i want to select the rows only on virtual page with index n. the count of rows per page is stored into a variable (@rows_per_page) so i can change it. Can somebody tell me how can i do this?Thx. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-08-25 : 06:46:17
|
| sounds like you want to do somthing like.......http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28639 |
 |
|
|
|
|
|
How can I do fragment a table into virtual pages?