declare @tbinfo table (fid int ,fdata int)
insert @tbinfo values (1,1111)
insert @tbinfo values (2,2222)
insert @tbinfo values (3,3333)
insert @tbinfo values (4,4444)
insert @tbinfo values (5,5555)

declare @cid int
set @cid=1
--@cid==1,5 bad; 2,3,4 ok

select a.*,isnull(b.fprevid,-1) fprevid,isnull(c.fnextid,-2) fnextid
from (SELECT * FROM @tbInfo where fID=@cid ) a
left join (select top 1 @cid as fid,fid as fprevid from @tbinfo where fid<@cid order by fprevid desc) b on a.fid=b.fid
left join (select top 1 @cid as fid,fid as fnextid from @tbinfo where fid>@cid order by fnextid) c on a.fid=c.fid