DECLARE @i int
DECLARE @uuid varchar(40)
DECLARE @passport_id varchar(40)
DECLARE @user_name varchar(50)
DECLARE @true_name varchar(50)
DECLARE @password varchar(32)
DECLARE @unit_id int
DECLARE @unit_name varchar(256)
DECLARE @node_code varchar(10)
DECLARE @user_type varchar(10)
Set @i = 80461
WHILE @i < 5500000
BEGIN
print @uuid
Set @i =@i +1
set @passport_id = @uuid
SET @user_name = RIGHT('name' + CAST(@i AS varchar(10)),10)
set @true_name = @user_name
set @password = 123456
set @unit_id = 1
set @unit_name = '单位名字'
set @node_code = 1005
set @user_type = 2
insert into dbo.t_user_base_info (passport_id,user_name,true_name,password,unit_id,unit_name,node_code,user_type) values(@passport_id,@user_name,@true_name,@password,@unit_id,@unit_name,@node_code,@user_type)
END