Pagination In SQL Server 2005
October 29th, 2009
If you’ve used other flavors of SQL (such as MySQL or PostgreSQL) and now you have switched over to TSQL (Microsoft SQL Server) you may have noticed that there is no native way of doing pagination. In some SQL versions, pagination was as easy as “SELECT * FROM ‘myTable’ LIMIT 0, 10″ and that would [...]