SQL Server

MSSQL Programming

Zyxware default image3
| 9 min read
When retrieving large number of records from a database table it becomes essential to do some kind of pagination while presenting the data to the end user. There are two ways of doing this. One is a server side implementation and another is a client side implementation. Here we are presenting a completely dynamic server side pagination implementation where the client only has to tell the server the number of records the server has to return and the starting record number.