close
declare @page int
set @page =1
declare @pagesize int
set @pagesize =20
declare @pagestart int
set @pagestart = (@page * @pagesize) - @pagesize;
declare @pageend int
set @pageend =(@page * @pagesize) + 1;
select * from (SELECT row_number()over(order by SeqNo) id, SeqNo, Account, Account_Status, ID_Number, Cell FROM Account) a
where a.id>@pagestart and a.id<@pageend
尚未使用,做紀錄
全站熱搜
留言列表