---上一条
select top 1 * from table1 where ID> 原记录的ID order by ID
---下一条
select top 1 * from table1 where ID <原记录的ID order by ID desc
--合起来为一个记录集
select top 1 * from table1 where ID> 原记录的ID order by ID
union all
select top 1 * from table1 where ID <原记录的ID order by ID desc
select top 1 * from table1 where ID> 原记录的ID order by ID
---下一条
select top 1 * from table1 where ID <原记录的ID order by ID desc
--合起来为一个记录集
select top 1 * from table1 where ID> 原记录的ID order by ID
union all
select top 1 * from table1 where ID <原记录的ID order by ID desc