下面存儲過程演示了如何在SQL中進行分頁，此存儲過程假設從Market表中檢索數據。

Create proc [dbo].[pageData]
         @curPage int,                     --當前頁索引
         @pageSize int                    --頁大小
        as
        begin 
            declare @before int,@sql varchar(8000)
            set @before=(@curpage-1)*@pageSize 
            set @sql='select top '+cast(@pageSize as varchar(10))+' * from Market where ID not in (Select top '+cast(@before as varchar(10))+' ID from Market order by ID)'
            exec (@sql) 
         end

從存儲過程的實現來看，效率較低。