after viewing examples of creating pagination function sql, have managed write following working code:
select * services order servicedateupdated desc offset @offset rows fetch next @recordsperpage rows only; today, after working line of code on year, have realized not used earlier versions of sql server 2012. current sql server version 2008.
how can re-write make work sql server 2008?
thanks in advance.
Comments
Post a Comment