| This is a good question. There is not real native way in MSSQL 2000, there are however some workarounds:
http://stackoverflow.com/questions/503566/efficient-paging-limit-query-in-sqlserver-2000
http://stackoverflow.com/questions/447623/what-is-a-good-way-to-paginate-out-of-sql-2000-using-start-and-length-parameters However, since this worked in Hibernate 4, I was hoping that someone familiar with the Dialects (and the refactoring that took place between 4 and 5) would simply be able to recover whatever workaround was implemented in 4 and port it to 5. I was browsing the 4.x branch on GitHub for this reason, but I was not able to actually find the workaround. |