SQL Server查询分页

      分页查询

总的查询语句如下所示:

SELECT * FROM (SELECT TOP 4200000000 ROW_NUMBER() over (order by t.strColumnName asc) as rownow,t.* from t_Column T   where 1=1  AND strChnID LIKE '%CH01%' order by t.strColumnName asc) X where rownow>=1 and rownow <=20

1.  1=1  AND strChnID LIKE '%CH01%'      为查询条件

2.   rownow>=1 and rownow <=20   标识所取的行数，可以变为rownow>=(Page-1)*PageIsze+1   and rownow <=Page*PageSize,表示取第几页