求能用的sql server储存分页程序

来源：百度知道 编辑：UC知道 时间：2024/06/13 10:47:56
求一个能用的sql server储存分页程序，没有参数的。写出sql语句和在asp中调用的语句，另外写个有一个参数的来，通过的话再加五十分，请高手帮帮忙，谢谢

drop table ItemData

create table [ItemData] (
[code] [char] (2) not null ,
[date] [datetime] not null ,
[iCode] [char] (11) not null ,
[itCode] [varchar] (20) not null ,
[cCode] [varchar] (10) not null ,
[pCode] [varchar] (10) not null ,
[fCode] [char] (2) null ,
[mvalue] [varchar] (50) null ,
[sys1] [varchar] (100) null ,
[sys2] [varchar] (100) null ,
-- constraint [pk_itemdata] primary key clustered
-- (
-- [code],
-- [date],
-- [iCode],
-- [itCode],
-- [cCode],
-- [pCode]
-- ) on [primary]
) --on [primary]
go

insert into ItemData(code,date,iCode,itCode,cCode,pCode)

select '03','2006-06-30 00:00:00.000','5','C1P','o','01'
union all
select '03','2006-06-30 00:00:00.000','5','C2P','o','01'
union all
select