set @T='B'+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)+replicate('0',8-len(cast(@i as varchar)))+cast(@i as varchar)
随机大写字母
char(rand()*26+65)+,
8位数字序号,自动补0
replicate('0',8-len(cast(@i as varchar)))+cast(@i as varchar)
随机小字字母
select char(rand()*26+97)