查询数据库中1到10000中漏掉的数据

如题,我想查询数据库中编号从1到10000中漏掉的数据(漏掉即指数据库中丢失的数据),可以查到吗?

http://topic.csdn.net/u/20090713/11/0f4e30d9-2a93-4e4b-900e-ab2734803e3d.html?8463

查漏号字段

做一个计数表，从1到10000的，将这个临时表left join你的表，找到你查询表中编号为NULL的计数表的值，这些就是漏掉的。

+1

SQL code

select number from 
( select number
from master..spt_values
where type='p'  and number<=2000 and number>=1
union all 
select number+2000
from master..spt_values
where type='p'  and number<=2000 and number>=1
union all 
select number+4000
from master..spt_values
where type='p'  and number<=2000 and number>=1
union all 
select number+6000
from master..spt_values
where type='p'  and number<=2000 and number>=1
union all 
select number+8000
from master..spt_values
where type='p'  and number<=2000 and number>=1 ) 
as a except (select 漏掉的数据的字段 from 漏掉的数据的表名)