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 |
|
walidkayrouz
Starting Member
2 Posts |
 Posted - 2007-08-02 : 11:48:00
|
| I want to Fetch Page in sqlserver 2005 we have the function ROW_NUMBERhow to do this in sqlServer 2000 for example from row 100 to 120 ? |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-02 : 12:14:56
|
| See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Efficient+paging+of+recordsets |
 |
|
|
walidkayrouz
Starting Member
2 Posts |
Posted - 2007-08-03 : 02:10:19
|
| I see the link, my problem that I dont have an ID in My table.I cant create a temporary table cause i dont want to do this manually. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-07 : 08:35:31
|
| "my problem that I dont have an ID in My table"Do you have a Primary key? (or some other unique index) If not there isn't really a way to do this.Kristen |
|
|
|
|
|
|
Paging in Sql server 2000