高效分页的相关存储过程

最新推荐文章于 2024-09-14 19:00:09 发布

leizhipan

最新推荐文章于 2024-09-14 19:00:09 发布

阅读量1.2k

点赞数

分类专栏：分页-效率-永远的话题文章标签：存储 sql go

本文链接：https://blog.csdn.net/leizhipan/article/details/1313504

版权

分页-效率-永远的话题专栏收录该内容

6 篇文章 0 订阅

订阅专栏

高效分页的相关存储过程

CREATE PROCEDURE GetProductByCategory
(
@categoryId int,
@pageSize int,
@pageIndex int
)
AS

DECLARE @sql nvarchar(4000)

SET @sql = 'select top '+cast(@pagesize as varchar(20))+' * from ProductInfo
    where CategoryId= '+cast(@categoryId as varchar(20))+'
    and ProductInfo.ProductId not in (select top '+cast((@pageSize*@pageindex) as varchar(20))
     + ' ProductID from ProductInfo where CategoryId ='
     +cast(@categoryId as varchar(20))+'order by productId) order by productId'
EXEC sp_ExecuteSql @sql