高手请进：如何提取int类型的Field中的不连续的数值！

[风中飘扬的柳絮]

table name : order_list
Field name : order_id int(4) not null

order_id 中存在有如下的资料：
——————————————————————————————————
order_id
___________
0
1
3
4
5
6
9
20
我如何用SQL来控制，提取缺少的编号，比如说：2,7,8,10,11等等....

高手，请指点

[愉快的登山者]

create table #t(id int)
declare @mx int
declare @i int
select @mx = max(order_id) from order_list
set @i = 0
while @i <= @mx
begin
if not exists (select * from order_list where order_id = @i)
insert into #t (id) values (@i)
set @i = @i + 1
end
select * from #t
go

[pengdali]

select top 100000 identity(int,1,1) id into # from sysobjects a,sysobjects b,sysobjects c

select * from # where id not in (select order_id from order_list)

drop table #