SQL循环插入数据

Student表，（ID，No，Name，Score）

Sql写法

declare @No int, @Name int
begin
set @No=2 
set @Name=1
while @No<=10
begin
insert into Student
values(newId(),@No,@Name,'1',CAST((rand()*300+ 100) as dec(10,0)) )
set @No=@No+1 set @Name=@Name+1
end
end