SQL Server stored procedure paging management

Tag: des IO data CTI Management database SQL

-- =============================================
--Author: <author: Liu Chang >
--Create Date: <create date:2014-07-31>
--Description: <description:sqlserver R2 Database paging stored procedure >

-- =============================================
CREATE PROCEDURE Pr_pager
(@pageIndex int,--pages
@pageSize INT--Number of rows per page
) as
Select Top (@pageSize) Productid,productnumber,name from Production.Product
Where ProductID not in (select Top (@pageSize * (@pageIndex-1)) ProductID from Production.Product)
--Query According to the primary key

Pr_pager @pageindex =1, @pageSize = 10--Enter the data you want to query