General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
>>Actually, your are right. What I meant to say was after opening a cursor I want to issue a "FETCH ABSOLUTE intPos" to go to a specific record then return the next 100 entries form that cursor, rather than return the whole cursor and have ASP process it.
>
>This sounds like "paging". I use a table variable (SQL Server 2000) with an IDENTITY column to create the row number. Then a simple BETWEEN get the section of rows that are of interest. I was surprised as the speed that SQL Server can handle this.
>
>-Mike
This sounds interesting. What is a table variable? I'm using SQL 7 so how would I get this done using this approach?
Thanks for the help...
Mike
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only