生成AA****XXXX格式的数据

生成以
AA****0001
AA****0002
...
AA****5000
....

格式的数据(其中****为随机数)

----------------------------------------------------------------

declare @n int
declare @str varchar(20)
declare @a int
declare @b int
set @a=1000
set @b=9999
set @str='AA'
set @n=1
while (@n<=2000)
begin
print @str+cast(cast(rand()*(@b-@a+1) as int)+@a as varchar(10))+case len(cast(@n as varchar(20)))
   when 1 then '000'+cast(@n as varchar(20))
   when 2 then '00'+cast(@n as varchar(20))
   when 3 then '0'+cast(@n as varchar(20))
   when 4 then cast(@n as varchar(20))
   end
set @n=@n+1
end

转载于:https://blog.51cto.com/bxbx258/122342