通用单表分页语句

这个可以写成存储过程,也可用于拼接语句,比较灵活            

string sql = "Select " + colums + " FROM (select ROW_NUMBER() Over(order by " + sort + " ) as rowId, " + colums + " from " + table + " where " + where + " ) as tempTable where rowId > " + startSize + " and rowid < " + endSize;

posted on 2012-03-02 10:07  丰云  阅读(72)  评论(0编辑  收藏  举报

导航