SQL Paging SQL SERVER 2008

 PublicIlist<userinfo> Getpagelist (intPageSize,intPageIndex, out intTotalitemcount) {    varTotalsql ="SELECT COUNT (1) from UserInfo"; Object result=getscalar (Totalsql); Totalitemcount= result = =NULL?0: Converthandler.toint32 (Result); varsql =string. Format (@"Select U2.N, u.* from UserInfo U, (select TOP {0} row_number () Over (ORDER by Name DESC) N, CODE from UserInfo) u2 WHERE U.code = U2. CODE and U2.N >= {1} ORDER by U2.N ASC", ((@pageIndex-1) * @pageSize) + @pageSize, ((@pageIndex-1) * @pageSize) +1); returnGetList (SQL);}

The Internet selected a page of SQL, do enough. Program local, database million net space comes with MSSQL 2008, if the database is put locally do not know how much faster.

SQL Paging SQL SERVER 2008