SQL Server Performance Forum – Threads Archive
rowguidcol………query…….hi all i have 100 rows in a table ‘krish’….i need the rows from 20 to 40 in the current state in the table…..how do i do that? write a query for that… will it use rowguidcol……..
record are not store in the database in any particular order. There isn’t a first row or last row or even 20th or 40th row of record. You define the sequence of record you want during retrieving using the ORDER BY clause. ie SELECT .. . . FROM .. . ORDER BY. Are you using SQL Server 2005 ? You can make use or row_number() function. Check out the Books Online for further detail
You need Pagination
http://www.aspfaq.com/show.asp?id=2120 Madhivanan Failing to plan is Planning to fail