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