各位帮忙看看这帖（http://www.csdn.net/expert/TopicView.asp?id=431789）

Question

sqlserver:
declare @a int
declare @x int
declare @b varchar(2)
select @a=ascii('0')
loop:
if @a < =ascii('Z') 
begin
  select @x=ascii('0')
  loop1:
  select @b= char(@a)
  if @x < =ascii('Z') 
  begin
    select @b= @b+char(@x)
    print @b 
    if @x= ascii('9')
    begin
      select @x=ascii('A')
    end
    else
    begin
      select @x=@x+1
    end
    goto loop1
  end
  if @a= ascii('9')
  begin
    select @a=ascii('A')
  end
  else
  begin
    select @a=@a+1
  end
goto loop
end

Answer 1

declare @fir int
declare @sec int
declare @charout varchar(2)select @fir=ascii('0')
while @fir<=ascii('z')
  begin
    select @sec=ascii('0')
      while @sec<=ascii('z')
        begin
          select @charout=char(@fir)+char(@sec)
          print  @charout
          if @sec=ascii('9') select @sec=ascii('A') 
            else if @sec=ascii('Z') select @sec=ascii('a') 
             else @sec=@sec+1
        end          
            if @fir=ascii('9') select @fir=ascii('A') 
            else if @fir=ascii('Z') select @fir=ascii('a') 
             else @fir=@fir+1
   end

Answer 2

楼上有误
declare @fir int
declare @sec int
declare @charout varchar(2)select @fir=ascii('0')
while @fir<=ascii('z')
  begin
    select @sec=ascii('0')
      while @sec<=ascii('z')
        begin
          select @charout=char(@fir)+char(@sec)
          print  @charout
          if @sec=ascii('9') select @sec=ascii('A') 
            else if @sec=ascii('Z') select @sec=ascii('a') 
             else select @sec=@sec+1
        end          
            if @fir=ascii('9') select @fir=ascii('A') 
            else if @fir=ascii('Z') select @fir=ascii('a') 
             else select @fir=@fir+1
   end