T-SQL生成随机记录

create table #s(id int identity(1,1) primary key,name nvarchar(20),age int)
declare @i int
set @i = 1
while(@i<=10)
begin
	insert into #s(name,age) values(left(newid(),8),rand()*100)
	set @i = @i + 1
end
select * from #s
drop table #s

create table #s(id int identity(1,1) primary key,name nvarchar(20),age int)
go --必需
insert into #s(name,age) values(left(newid(),8),rand()*100)
go 10 --执行10次
select * from #s
drop table #s