sql age20-30,name5字符、插入耗时、100道加法题

一、

create table tb1

(nm varchar(10),
ag int)
drop table tb1
--select rand()*11
--select cast (floor (rand()*10) as int)
--姓名5字符 ag20-30




declare @nn varchar(10),@gg int
declare @i int,@j int 
set @i=1
while @i<=100


begin
   set @nn=char(rand()*58+65)
   set @j=1
   while @j<=4
   begin
   set @nn=@nn+char(rand()*58+65)--得到5个
   set @j=@j+1
   end


   set @gg=rand()*11+20
   insert into tb1 values(@nn,@gg)
   set @i=@i+1
end

select *from tb1

二、

create table p1(nid varchar(40),num int)
declare @i int ,@nd varchar(40),@nn int,@dd datetime
set @i=1
set @dd=getdate()
while(@i<=10000)
begin
set @nd=newid()
set @nn=rand()*10000
insert into p1 values(@nd,@nn)
set @i=@i+1
end
select datediff(ms,@dd,getdate())

三、

declare @pl1 int,@pl2 int,@pl3 int,@i int ,@n int,@d char
set @i=1
set @n=0
set @d= '='
while @i<=100
begin
   set @pl1=rand()*100
   set @pl2=rand()*100
   set @pl3=@pl1+@pl2
   if @pl3<100 and @pl3>=10  
 begin
   set @n=@n+1
insert into plus values(@n,@pl1,@pl2,@pl3)
   set @i=@i+1
 end
end
--select * from plus