2012年12月8日
SQLServer 查询表 Id 或编号的缺失范围（也称为间断）
摘要： select istart, iend, iend - istart + 1 as imiss from (select ibillid + 1 as istart, (select min(ibillid) from stCardBill as b where b.ibillid > a.ibillid ) - 1 as iendfrom stCardBill as awhere not... 阅读全文
posted @ 2012-12-08 11:03 资州知府 阅读(2111) 评论(0) 推荐(0) 编辑