alter proc page
@pageIndex int
as
declare @strSql varchar(500)
set @strSql = 'select top 3 * from MESSAGE where messageID >
(select max(messageID)
from (select top '+str((@pageIndex - 1)*3)+ ' * from MESSAGE order by messageID asc) as tmp)
order by messageID asc'if (@pageIndex = 1)
set @strSql = 'select top 3 * from MESSAGE'exec (@strSql)
go
exec page 1
用这个在数据库中创建存储过程
直接调用存储过程就可以了
@pageIndex int
as
declare @strSql varchar(500)
set @strSql = 'select top 3 * from MESSAGE where messageID >
(select max(messageID)
from (select top '+str((@pageIndex - 1)*3)+ ' * from MESSAGE order by messageID asc) as tmp)
order by messageID asc'if (@pageIndex = 1)
set @strSql = 'select top 3 * from MESSAGE'exec (@strSql)
go
exec page 1
用这个在数据库中创建存储过程
直接调用存储过程就可以了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货