06 2011 档案
摘要:最近做项目不允许用存储过程,所以分页的时候就用了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.
阅读全文