创建两个数相加生成100条记录:
create database db01--创建数据库
create table sumdemo01( numID int,num01 int,num02 int,result int)--创建表
select * from sumdemo01
declare @numID int,@num01 int,@num02 int ,@result int,@n int
set @numID=0
set @n=0
while @n<100
begin set @num01=rand()*100
set @num02=rand()*100
set @result=@num01+@num02
--判断结果为>150时插入
if(@result>150)
begin
set @n=@n+1 --负责跳出循环
set @numID=@numID+1
insert into sumdemo01 values(@numID,@num01,@num02,@result)
end
end
--查询记录
select * from sumdemo01 --
--删除记录
delete from sumdemo01