Another Prime Number Generator

set nocount on

declare 
@prime Table(
primen bigint not null primary key
)
declare 
@index bigint, 
@upper_bound bigint

select 
@upper_bound = 100000,
@index = 3

insert into @prime values (2)

while 
@index <= @upper_bound 
begin
insert
@prime
values
(@index)

select @index = @index + 2
end


select @index = 3

while 
@index <= (sqrt(@upper_bound)) 
begin
delete 
@prime 
where 
primen % @index = 0 and 
primen > @index

select @index = @index + 2
end

select * from @prime