存储过程上一篇下一篇
在做web项目时经常遇到新闻要上一篇,下一篇,自己先记下以纺万一忘记了
上一篇
create proc Prev
(
@ID
)
as
declare @Record int
set @Record = (select count(ID) from News where ID<@ID)
if @Record>0
begin
select top 1 ID from News where ID<@ID order by ID desc
end
else
begin
select max(ID) from News
end
下一篇
create proc Next
(
@ID
)
as
declare @Record int
set @Record = (select count(ID) from News where ID>@ID)
if @Record>0
begin
select top 1 ID from News where ID>@ID
end
else
begin
select min(ID) from News
end
create proc Prev
(
@ID
)
as
declare @Record int
set @Record = (select count(ID) from News where ID<@ID)
if @Record>0
begin
select top 1 ID from News where ID<@ID order by ID desc
end
else
begin
select max(ID) from News
end
下一篇
create proc Next
(
@ID
)
as
declare @Record int
set @Record = (select count(ID) from News where ID>@ID)
if @Record>0
begin
select top 1 ID from News where ID>@ID
end
else
begin
select min(ID) from News
end
作者:蓝丶 sky
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。