用存储过程写随机生成100个用户名和密码

CREATE PROCEDURE [dbl].[CreateRandUser]
z JV"T*tg dE&Pw65703AS
_|\!HN~ ~x65703
^3w/h[%N{)C\{65703--生成随机用户名密码51Testing软件测试网7M eju [.L
--创建测试环境
f)@ gXsB65703set nocount on
osIMj ~0i65703
/J+KWO#tp/GWB65703--创建字符集
\-jE6b1d65703create table #1
2y;n]&YlH65703(51Testing软件测试网gs-MQM H!lG{
     [rnum] varchar(5)
Q:hh$?l"?w65703)51Testing软件测试网(w?Qx H6q a
declare  @i  int
oL?8n0Qms-g!a@65703set @i=0
[+|J_NR*T&N65703
TI{p]d$]65703--插入０－９十个数字，不需要数字可注释下面代码
)A%^^1{Np3\65703while @i<10
3p+G n"sT
cE&n*]65703begin
X)A{PZ
_/Hl`S65703     insert #1 select @i51Testing软件测试网+eq~
N5i%y
     set @i=@i+151Testing软件测试网 P
jBnly
end51Testing软件测试网,`L|caJ@}n
--插入A-Z26个字母51Testing软件测试网[_2V`x*G Hf;o6p
set @i=ascii('A')51Testing软件测试网1j Z+IRd8ij.[6e
while @i<=ascii('Z')
Eh }$^ag65703begin51Testing软件测试网*GpR.p(sd OF
    insert #i select char(@i)51Testing软件测试网 P A+om)r*Cq/X
    set @i=@i+1

BeMf U(\65703end
D(^8Ck.n X9_ D/A;MN65703--创建目标表存储过程
(~"|'P2ilW
{65703create table Result51Testing软件测试网 gx-L k!` x
(
2p JEC/F65703     ID int identity,username varchar(50),pwd varchar(50)51Testing软件测试网C k] j{+q3?
)51Testing软件测试网(Ax)B)ONm2h
--插入数据
l|+~,D&E/c(I:VG)]&e-g65703declare @tmpuser varchar(100)
Z%at8FA6y#E65703declare @tmppwd varchar(100)
7K!qjK a
o`65703select @tmpuser='',@tmppwd='',@i=1
"F!pF e[5qax0IZ65703while @i<=100                   --生成１００条结果集
2H2u&[PioZV65703begin
js2guKX a65703    select @tmpuser=@tmpuser+rnum from (select top 5 rnum from #1 order by newid())A51Testing软件测试网p4[#R-iBf$q3B
    select @tmppwd=@tmppwd+rnum from (select top 5 rnum from #1 order by newid())A51Testing软件测试网R2A"u"hP
    insert Result(username,pwd) select'admin_'+@tmpuser,'pwd_'+@tmppwd51Testing软件测试网Ml FD
a ~%H!H$X
    set @i=@i+1
2D$Aj~P_~0||65703    set @tmpuser=''
7Sx6{p eXe65703    set @tmppwd=''51Testing软件测试网&~ Qd4Q.mR;s:D
end

--查看
F+G,A8w8j9m_:WC65703select * from result51Testing软件测试网 i/`[&rK0hSo
--删除测试环境
Q@)x*~bk'~65703drop table #151Testing软件测试网"| K7K!_0NQ/J-m|
go