Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to create a paging stored procedure for sales order detail:

USE AdventureWorks;

GO

CREATE PROC dbo.procSalesGetPageOfData(

           @PageSize AS INT,

           @PageNo   INT)

AS

  BEGIN

    WITH ctePaging

         AS (SELECT TOP ( @PageSize * @PageNo ) Row_number()

                     OVER(ORDER BY SalesOrderID, SalesOrderDetailID) AS SeqNo,

                                                OrderQty,

                                                UnitPrice,

                                                LineTotal,

                                                ModifiedDate

             FROM   Sales.SalesOrderDetail)

    SELECT *

    FROM   ctePaging

    WHERE  SeqNo > ((@PageNo - 1) * @PageSize)

  END

GO

EXEC dbo.procSalesGetPageOfData

  10 ,

  351