select top 1 * from News where NewsID>getid --下一条新闻
select top 1 * from News where NewsID<getid order by NewsID desc --上一条新闻
select top 1 * from News where NewsID>getid --下一条新闻
select top 1 * from News where NewsID<getid order by NewsID desc --上一条新闻
转载于:https://www.cnblogs.com/UouHt/archive/2008/11/26/1341184.html