一、
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