create procedure InsertTest as begin declare @i int declare @s varchar(20) set @i=1 while @i<=100 begin select @s=cast(@i AS varchar(20)) insert into test (A,B,C,D) VALUES ('a'+@s,'b'+@s,'ccccc','ddddd') SET @i=@i+1 end end 转载于:https://my.oschina.net/u/3711831/blog/1785791