create table student

 (

 id varchar(50), --编号

 class varchar(50),--课程

 soure int --成绩

 )

 go

 declare @i int

 set @i = 0

 while @i<30

 begin

 --插入数据

 declare @r int

  exec awf_RandInt 50,100,@r output

 insert into student values(''+@i,'语文',@r)

 --修改数据

 exec awf_RandInt 0,30,@r output

 update student set class = '数学' where id = @r+''

 --修改数据

 exec awf_RandInt 0,30,@r output

 update student set class = '英语' where id = @r+''

 set @i=@i+1

 end

 select * from student

 --生成随机整数

 create procedure awf_RandInt

    @min int,

    @max int,

    @result int output

 as

 begin

     set @result= cast((rand()*(@max-@min)+@min) as int)

     return @result

 end