I am used to working in MySQL, and am now working with MS SQLServer :(
I'm hoping someone else has been in this unfortunate situation before and can help me
out.
I'm looking to do pagination of some resultset in JSP.
in MySQL I would have used something like:
SELECT * FROM mytable ORDER BY somedatefield LIMIT 20,30
to get the third page of results with 10 results per page.
MSSQL offers me NOTHING as kind as LIMIT.
I have a query that returns ~60,000 results, and I don't want to have to grab them all
on each page,
and then move to the range that I need.
Thanks for the help,
MIchael
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
