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 |
|
jeantiger
Starting Member
5 Posts |
 Posted - 2007-08-03 : 06:25:23
|
| Hello If i have a select query and i need to get it result by paging(for example from row x to row y ) without using cursor .Is there any way to do it ?Nb : Maybe like ROW_NUMBER in SqlServer 2005 and ROWNUM in oracle. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-03 : 06:44:34
|
| http://weblogs.sqlteam.com/jeffs/archive/2004/03/22/1085.aspxMadhivananFailing to plan is Planning to fail |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Paging in Sqlserver 2000