如何使用mssql实现jqgrid的后端分页

Hey guys so I am currently using jqgrid with an mssql database, I am trying to get my paging to work for mssql, for mysql I know you can use the limit command but unfortunately that does not exist in MSSQL, so does anyone know how i can properly page using mssql? Also, i need it to be able to work with search so i cant guarantee a constant number such as row number because the row numbers could vary during search. Thanks!Hey guys so I am currently using jqgrid with an