Begin Declare @n bigint set @n=0 while @n<100000 begin insert into AdminLoginLog (createtime,ipaddress,userid,logintype) values(getdate(),'192.168.1.111',333,newid()) set @n=@n+1 End end