用户表 UserData
ID,PHOTO存储过程的功能用来翻页,参数如下
@PageSize int=9,--每页的大小(行数)
@PageCurrent int=1,--要显示的页
@RSCount int=0 output
当用户PHOTO为空的时候,跳过
ID,PHOTO存储过程的功能用来翻页,参数如下
@PageSize int=9,--每页的大小(行数)
@PageCurrent int=1,--要显示的页
@RSCount int=0 output
当用户PHOTO为空的时候,跳过
create proc p_test
@pID int,
@pPHOTO image,
@PageSize int=9,--每页的大小(行数)
@PageCurrent int=1,--要显示的页
@RSCount int=0 output
as
begin
if ( @pPHOTO is not null)
begin
//
end
end
DECLARE @pagenum AS INT, @pagesize AS INT
SET @pagenum = 2
SET @pagesize = 3
SELECT *
FROM (SELECT ROW_NUMBER() OVER(ORDER BY newsid DESC) AS rownum,
newsid, topic, ntime, hits
FROM news) AS D
WHERE rownum BETWEEN (@pagenum-1)*@pagesize+1 AND @pagenum*@pagesize
ORDER BY newsid DESC