分页存储过程（小列子）

ALTER PROCEDURE [dbo].[Product_GetListPageCateId]
-- Add the parameters for the stored procedure here
@CateId int,
@Order varchar(20),
@startIndex int,
@EndIndex int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
if(@Order='Price')
begin
select * from (select row_number() over (order by ProductId)
as RBank,* from Product where categoryid=@CateId) as Bank
where RBank between @startIndex and @EndIndex order by Price Desc
end
else
begin
select * from (select row_number() over (order by ProductId)
as RBank,* from Product where categoryid=@CateId) as Bank
where RBank between @startIndex and @EndIndex order by publishDate Desc
end
END