2010年8月7日
SQL查询当前数据上一条和下一条的记录
摘要： id是指当前数据news_id参数方法一：stringpreSql = "select top 1 * from news where news_id< "+id+" order by news_idDESC"stringnextSql = "select top 1 * from news where news_id> "+id+" order by news_idASC"方法二：s... 阅读全文
posted @ 2010-08-07 03:21 NetGao 阅读(3184) 评论(1) 推荐(1)