sql server 中的存储过程

create  procedure insertdata
as
 DECLARE @count INTEGER
 DECLARE @index INTEGER
 set @index = 1
 set @count = 1000
 while @index < @count
 begin
    insert into a_employee(id, name, birthdate, age, phone, adress) values(@index, 'mingtian', '2013-11-15', '20','18830129153', '石家庄'); 
    set @index = @index + 1;
end;

 

exec   insertdata;