Code --@Tablename 表名 --@Orderby 排序的字段名 --@Index 页码 --@Size 页大小 ALTERPROCEDURE uspPaging @Tablenamevarchar(20),@Orderbyvarchar(20),@Indexint=1,@Sizeint=10 AS BEGIN DECLARE@sqlVARCHAR(500) SET@sql='SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY '+@Orderby+') AS ID,* FROM '+@Tablename+') AS temp WHERE ID BETWEEN ('+CAST(@indexASVARCHAR(5))+'-1)*'+CAST(@sizeASVARCHAR(5))+'+1 AND '+CAST(@index*@sizeASVARCHAR(5)) EXEC(@sql) END