3.21上机练习

create database db01create table ssq(red1 int,red2 int,red3 int,red4 int ,red5 int,red6 int,blue1 int)select * from ssq--后一位的数字比前一位要大一declare @r1 int ,@r2 int ,@r3 int ,@r4 int ,@r5 int ,@r6 int ,@b1 int  set @r1=1 while @r1<28 begin  set @r2=@r1+1  while @r2<29  begin   set @r3=@r2+1   while @r3<30   begin    set @r4=@r3+1    while @r4<31    begin     set @r5=@r4+1     while @r5<32     begin      set @r6=@r5+1      while @r6<33      begin       set @b1=1       while @b1<16       begin       insert into ssq values(@r1,@r2,@r3,@r4,@r5,@r6,@b1)       set @b1=@b1+1       end      set @r6=@r6+1      end     set @r5=@r5+1     end    set @r4=@r4+1    end   set @r3=@r3+1   end  Set @r2=@r2+1  end set @r1=@r1+1 endselect * from ssq delete ssq----create table sum(num01 int,num02 int,sum01 int)select * from sumdeclare @n1 int ,@n2 int,@n3 int,@temp intset @temp=1 --while语句包含begin end--if语句包含end一一对应while @temp<150begin  set @n1=rand()*100 set @n2=rand()*100 set @n3=@n1+@n2 if @n3>150 begin  insert into sum values(@n1,@n2,@n3) set @temp=@temp+1 endenddelete sum----create table jsj1614(xueyuan varchar(20),xingming varchar(20),banji varchar(20),xeuhao varchar(20))select * from jsj1614  --bulk后面是insertbulk insert jsj1614--盘符后跟反斜杠from 'd:\daoru.txt'with (fieldterminator=' ',rowterminator='\n')select * from jsj1614----create table nameorder(id varchar(20),name varchar(20),sex varchar(20),birth varchar(10),address varchar(20),tel varchar(20))select * from nameordercreate table tb(nm varchar(20),age int)select * from tb--生成随机记录：declare @nm varchar(10),@age int,@i int,@j int set @i=1while @i<10000 begin  set @nm=char(RAND()*58+65) set @j=1 while @j<=4 begin  set @nm=@nm+char(RAND()*58+65)  set @j=@j+1 end set @age=RAND()*11+20 insert into tb values(@nm,@age) set @i=@i+1 endselect * from tb ----