摘要：
最近做项目不允许用存储过程，所以分页的时候就用了SQL语句。如下:declare@Countintdeclare@Pageintset@Count=10set@Page=2selecttop(@Count)FEBId,FPName,FETName,FEBOrderSerial,FEBState,FEBEventDatefrom(selectFEBId,FETName,FPName,FEBOrderSerial,FEBState,FEBEventDate,ROW_NUMBER()over(orderbyFEBIddesc)asRowNumberfrom(selectFE.FEBId,FP.FP. 阅读全文