Hi guys!
This is my first post here, I used to post a bit a long time ago on PHP Builders but the site appears to have mostly died.
Recently I started my first project working with MSSQL (I always worked with MySQL before) and while I have found some differences and hurdles I had to jump over and learn about some were frustrating like paging query results with having LIMIT available in MSSQL.
I was wondering with the new OFFSET and FETCH NEXT introduced with MSSQL 2012 if anyone had used these to setup their pagination on the pages and if so, do you have a basic example of how it was done? I learned about this new feature in MSSQL 2012 today so I upgraded the database in hopes it would be simpler to implement the paging of the results.
Thanks!