mssql 分页程序

来源：互联网发布：扫雷c语言代码编辑：程序博客网时间：2024/04/29 19:24

1.写的一个mssql 数据分页程序

declare @sql nvarchar(4000)
declare @i int --当前页
set @i=2
select @sql=N'select top 10 * from set_ProductData
   where 1=1 and (ProductKey in
     (select top '+ Convert(nvarchar(10),@i*10 )+N' ProductKey
   from set_ProductData order by ProductKey asc))
   order by ProductKey desc'
print @sql
EXEC(@sql)

2.分页的另外一个例子

create table feia
(
a1 char(6) not null PRIMARY KEY,
a2 datetime ,
a3 varchar(10) ,
a4 varchar(10)
)

insert into feia
select '001201','2007-06-03','进货单1','王三'
union all
select '001211','2007-06-03','进货单2','张三'
union all
select '001231','2007-06-01','进货单3','王三'
union all
select '001241','2007-07-09','进货单4','谷三'
*/

declare @sql nvarchar(4000)
declare @i int --当前页
set @i=4
select @sql=N'select top 1 *
     from feia
     where (a1 in
     (select top '+ Convert(nvarchar(10),@i*1 )+N' a1 from feia order by a1 desc)
     ) order by a1 asc'
print @sql
EXEC(@sql)

--drop table feia