create table teachers(id int primary key not
null identity(10000,100),tea_name varchar(50),
tea_age int default 20)
create procedure insert1000teachers
as
declare @tea_name varchar(50)
declare @tea_age int
declare @index int
declare @count int
set @index=1
set @count=100
while @index<@count
begin
set @tea_age=30*rand()
set @tea_name='teacher'
set @tea_name=@tea_name+convert(varchar,@index)
insert into teachers(tea_name,tea_age)
values(@tea_name,@tea_age)
set @index=@index+1
end