下一篇select top 1 * from table1 where id>@id order by id 上一篇select top 1 * from table1 where id <@id order by id desc using(SqlConnection conn=new SqlConnection("")) {}
根据当前ID查找上一篇下一篇的ID create proc PrevNext ( @ID int )as select top 1 * from table where ID<@ID order by ID desc//上一篇 select top 1 * from table where ID>@ID
下一篇select top 1 * from table1 where id>@id order by id 上一篇select top 1 * from table1 where id <@id order by id desc通过这个查询出来上一篇和下一篇文章的id。然后通过url传参实现功能就是了
上一篇select top 1 * from table1 where id <@id order by id desc
using(SqlConnection conn=new SqlConnection(""))
{}
create proc PrevNext
(
@ID int
)as
select top 1 * from table where ID<@ID order by ID desc//上一篇
select top 1 * from table where ID>@ID
上一篇select top 1 * from table1 where id <@id order by id desc通过这个查询出来上一篇和下一篇文章的id。然后通过url传参实现功能就是了