How can I use SQL Server to provide results starting at a given offset? For example, in another SQL server, it's possible to do:
SELECT * FROM MyTable OFFSET 50 LIMIT 25
to get results 50-74. This construct does not appear to
exist in SQL Server.
Is there a way to do this where only the rows I am working
on get loaded?
September 17, 2013 5:57 PM
September 17, 2013 7:27 PM