Hibernate Community • View topic - Paging Options With SQL 2000

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Paging Options With SQL 2000

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

swatermasysk

Post subject: Paging Options With SQL 2000

Posted: Fri May 16, 2008 4:28 pm

Newbie

Joined: Fri May 16, 2008 4:23 pm
Posts: 1

I have an application which needs to support both SQL 2000 and SQL 20005. While doing some profiling, I noticed SQL 2000 was not doing the paging at the database level.

Is there anyway to configure SQL 2000 to do the paging in the database? If not, does anyone know of a custom dialect which handles this?

Thanks,
Scott

Top

FlukeFan

Post subject: Paging Options With SQL 2000

Posted: Wed May 21, 2008 10:15 am

Senior

Joined: Thu Jun 21, 2007 8:03 am
Posts: 127
Location: UK

Hi Scott,

The paging functions used in the 2005 dialect weren't introduced until SQL Server 2005. I am not aware of a dialect that implements complete paging for SQL2000.

Even the SQL 2000 dialect should use the TOP statement to limit the number of rows coming back.

Using the SQL 200 dialect, a query that has:

Code:

.SetFirstResult(10)
.SetMaxResults(10)

should issue something like:

Code:

SELECT TOP 20 FROM ...

and it just ignores the first 10 records of the result set.

Regards,
Richard

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum