web2py/web2py — pull request #259 by niphlod (2013-10-13 21:06:18+00:00)
Title: mssql 2012 support for pagination

enable true pagination support for MSSQL (only available on 2012). Has a quirk, though: if there's no order specified, the new statements can't be used (probably a good limitation).
So, this adapter adds a truly random orderby clause, inferring that the user indeed "seeked" randomness not specifying a proper orderby statement (currently achievable only if select(limitby=(0,10), orderby_on_limitby=False))