快速增加sql数据

declare @i int
set @i=0
while @i<10
begin
insert into dbo.w10test(Name) select Name from dbo.w10test 
set @i=@i+1
end;
原文地址:https://www.cnblogs.com/John-Marnoon/p/6114307.html