SQL循环插入测试数据，免得一条条录入了

declare   @a   int  
  set   @a=0  
  while   @a<=10  
  begin  
                cast(@a as varchar(50))
                set   @a=@a+1  
  end

------------------------
DECLARE @i int
DECLARE @name varchar(10)
DECLARE @password varchar(10)
Set @i = 10000

//开始循环插入数据；
WHILE @i < 100000
BEGIN
Set @i =@i +1
SET @name = RIGHT('00000' + CAST(@i AS varchar(10)),5)
set @password = @name
insert into admin values(@name,@password,@i,1,'zhyx@163.com','15101185909','beijing')
END