存储过程:
GetProductsCount1:
CREATE PROCEDURE GetProductsCount1 AS
select count(*) from test
GO
GetProductsByPage:
CREATE PROCEDURE GetProductsByPage
@PageNumber int,
@PageSize int
AS
declare @sql nvarchar(4000)
set @sql = 'select top ' + Convert(varchar, @PageSize) + ' * from test where id not in (select top ' + Convert(varchar, (@PageNumber - 1) * @PageSize) + ' id from test)'
exec sp_executesql @sql
GO
前台代码:
后台代码: