create table a(name varchar(10),id int default 0)
insert into a(name)
select 'a'
union select 'b'
union select 'c'
union select 'd'
union select 'e'
insert into a values('f',2)
insert into a(name) values('h')
go
select * from a
----
name id
a 0
b 0
c 0
d 0
e 0
f 2
h 0