数据翻页--存储过程实现

 CREATE PROCEDURE GET_PAGE_LIST
  @uid bigint, -- 用户ID
 @id bigint, -- 主键
 @forward int, -- 为0首页、1是下翻页，2上翻页、3末页
 @num int
AS
  if @forward = 0 
   select top (@num) id,trans_id,user_id,in_date,op_uid,detail
    from user_money_detail with(nolock) 
    where user_id = @uid 
    order by in_date desc
  -- 向下翻页
  if @forward = 1
   select top (@num) id,trans_id,user_id,in_date,op_uid,detail
    from user_money_detail with(nolock)
    where user_id = @uid  and id < @id
    order by in_date desc
  -- 向上翻页
  if @forward = 2
   select * from (
    select top (@num) id,trans_id,user_id,in_date,op_uid,detail
     from user_money_detail with(nolock) 
     where user_id = @uid  and id > @id 
     order by in_date
    ) x 
    order by in_date desc
  
 --尾 页
  if @forward = 3
   select * from (
    select top (@num) id,trans_id,user_id,in_date,op_uid,detail
     from user_money_detail with(nolock)
     where user_id = @uid 
     order by in_date
    ) x
    order by in_date desc