摘要： create procedure spGetDataByPage@pageIndex int,@pageSize intasbegindeclare @start int;set @start = (@pageIndex-1) * @pageSizeselect 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 阅读全文