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 |
|
cutepraba
Yak Posting Veteran
53 Posts |
 Posted - 2008-07-19 : 10:55:44
|
| Many of the asp pages are displaying 20 records per page.i.e.exapmle.com\test?page1 showing first 20 records.next previousexapmle.com\test?page2 showing next 20 records.Is it purely asp based or SQL based?____________Praba |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-19 : 10:58:01
|
Could be anything.Most practical is that ASP sends a parameter to database, and database returns that page records, and do the pagination at database.This is the reduce network traffic.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
cutepraba
Yak Posting Veteran
53 Posts |
Posted - 2008-07-19 : 11:00:04
|
| Can you tell me how to select 20 rows after the first 20 rows.____________Praba |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-19 : 12:32:17
|
quote:
Originally posted by cutepraba
Can you tell me how to select 20 rows after the first 20 rows.____________Praba
you can use ROW_NUMBER() function to achieve this if you're using SQL 2005http://blogs.x2line.com/al/archive/2005/11/18/1323.aspx |
|
|
|
cutepraba
Yak Posting Veteran
53 Posts |
Posted - 2008-07-19 : 12:38:07
|
| I am using sql server 8____________Praba |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-19 : 13:07:00
|
quote:
Originally posted by cutepraba
I am using sql server 8____________Praba
then use Peso's solution. |
|
|
|
|
|
|
Select 20 rows