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 |
|
andre
Constraint Violating Yak Guru
259 Posts |
 Posted - 2001-10-31 : 11:11:53
|
| This forum has had several questions about how to page a large group of records in a stored procedure without using a temporary table. Wouldn't this be neat: in the WHERE clause of a select statement you could specify the range of the internal row numbering of the recordset. When SQL Server is gathering records, it must store them in some sort of an array just in case you use an ORDER BY clause. Maybe we could request the ability to access the array by doing something like this:SELECT * FROM table WHERE Keywords LIKE '%the%' AND ROWNUMBER>=1 AND ROWNUMBER<=10This would display the first 10 records. ROWNUMBER would need to be a reserved word, but wouldn't this be a feature worth requesting? |
|
|
|
|
|
Feature for SQL Server 2002