mssql 分页程序

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