摘要：
分页select * from (select *, Row_NUMBER() over(order by 列名) as num from 表) as twhere num between 1 and 5order by timedesc存储过程create proc usp_GetPage @pageIndex int, --页码 @pageSize int, --页容量 @pageCount int output --共多少页as declare @n int select @n=COUNT(*) from 表 set @pageCount =c... 阅读全文
