create table a (id int identity(1,1) not null , name varchar(20))
declare @i int
set @i = 1
while (@i < 30 )
begin
insert a (name) values('name' + Convert(varchar(10),@i) )
set @i = @i + 1
end
create table a (id int identity(1,1) not null , name varchar(20))
declare @i int
set @i = 1
while (@i < 30 )
begin
insert a (name) values('name' + Convert(varchar(10),@i) )
set @i = @i + 1
end