Geekdojo

What I would like ROWNUM , LIMIT, etc

• SELECT TITLE FROM BOOK WHERE ROWNUM <= 5 ORDER BY TITLE  
• SELECT * FROM BOOK WHERE RowNumber BETWEEN 11 AND 20
• SELECT * FROM BOOK  WHERE userID = colname LIMIT 2
• SELECT * FROM BOOK LIMIT 20, 10

... y no tengo

1. Sent from  the client to the server the last register and the server performs a new query ("Registro de reenganche")
2. Cache en Cliente y Servidor???
3. Something that remember DIME???

Referencias:

http://www.windowsitpro.com/SQLServer/Article/ArticleID/40505/40505.html

http://weblogs.asp.net/pwilson/archive/2003/10/10/31456.aspx

http://www.windowsitpro.com/SQLServer/Article/ArticleID/43922/43922.html

http://www.codeproject.com/cs/database/PagingSqlNet.asp

http://www.codeproject.com/aspnet/PagingLarge.asp

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=31741

Referencias RowNum / RowNumber

http://www.joesack.com/SQLServerROWNUM.htm