批量创建用户脚本

declare @count int
declare @i int
declare @username varchar(20)
declare @no varchar(3)          //定义变量

set @count = 20                //设置循环数(也就是添加用户数)
set @i=1

while @i<=@count
begin
   if (@i < 10)
   begin
 set @no = '0' + convert(varchar(20),@i)  
   end                                            //当数目小于10的时候,以0+count显示,否则直                                                    接显示
   else
   begin
 set @no = convert(varchar(20),@i)  
   end 

   set @username = 'user' + @no                   //用户名前缀+@count
  INSERT INTO t_userinfo(username,userpassword,displayname,status,accounts)
                VALUES(@username,'b59c67bf196a4758191e42f76670ceba',@username,'1',@username)  

   set @i=@i+1
end