SQL Server doesn’t have a LIMIT function like MySQL, but a little digging with Google turned up a query that looks something like this:
SELECT test.*
FROM (
SELECT test.*, ROW_NUMBER() OVER (ORDER BY TS_TEST_ID) AS row FROM test
) test
WHERE test.row BETWEEN 10 and 15
based on this post on Stack Overflow:
http://stackoverflow.com/questions/5151013/limit-style-functionality-in-ms-sql-server-2005
Fijiaaron 