返回tNews中的第n页的m条数据

create procedure spGetDataByPage
 @pageIndex int,
 @pageSize int
as
begin
 
 declare @start int;
 set @start = (@pageIndex-1) * @pageSize
 
select top(@pageSize) * from tNews where  News_PKID  not in
(select top(@start) News_PKID  from tNews order by News_PKID  ) order by News_PKID
end