新增函数row_number() :依照群组显示每条记录在该群组中出现的顺序位置,在显示每条记录编号时非常有用,并且搭配OVER子句。
create Proc fy @iRowCount INT,@iPageNo INT
as
select * from (
select row_number() over (order by xm) row,xm from table1 ) table1
where row between @iRowCount*(@iPageNo-1)+1 and @iRowCount*@iPageNo
order by xm
go
exec fy 5,2