declare @counter int set @counter=0 while (@counter<100) begin insert into UserInfo(userid,userName)values('10','luokuan') set @counter=@counter+1 end