
declare @d datetime,@id int
set @id=5
set @d=(select fmeta from tnotes where fid=@id)
--上一篇
select top 1 fid,ftitle,fmeta
from (select top 1 fid,ftitle,fmeta
from tnotes where fmeta>@d order by fmeta)t
--当前篇
select top 1 fid,ftitle,fmeta from tnotes where fid=@id
--下一篇
select top 1 fid,ftitle,fmeta
from (select top 1 fid,ftitle,fmeta
from tnotes where fmeta<@d order by fmeta desc)t