最原始的分页存储过程

create proc [dbo].[proc_showvideo]
(
@pageindex int,//页码
@pagesize int,//每页显示条数
@strWhere varchar(150)='',//查询条件
@orderfieldstr varchar(12)=''//排序方法
)
as

declare @begin int,@end int,@orderfield varchar(12)
set @begin=(@pageindex-1)*(@pagesize)+1
set @end=(@pageindex)*(@pagesize)
set @orderfield='ClickCount'//默认按点击次数排序

if(@orderfieldstr!='')
begin
        set @orderfield = @orderfieldstr
        
    end

exec('select * from
(
select row_number() over(order by ' + @orderfield + ' desc) as rowNum,
Id,Title,VideoContent,UpTime,TopType,OrderField,ImgPath,ClickCount,CommentCount from Video where 1=1 ' + @strWhere + '//红色部分为查询语句
) as c
where c.rownum between '+ @begin +' and ' +@end+ ' order by ' + @orderfield + ' desc')