--新建一个表T_employee包含(fnumber,fdate,fage,fsalary)
create table T_employees(fnumber varchar(20) ,fdate varchar(20),fage int,fsalary decimal(10,2),primary key (fnumber))
--循环插入60行数据
declare @i int
declare @number varchar(20)
set @i =1
while(@i<60)
begin
--循环体
--设置主键从00001开始
set @number = RIGHT('0000'+CAST(@i as varchar(20)),5)
insert into T_employees values (@number, convert(varchar(19),getdate(),120),null,null)
set @i=@i+1
end