declare @zmb table (zm char)declare @i intset @i=ascii('A')while(@i<=ascii('Z'))  begin    insert into @zmb values(char(@i))    set @i=@i+1  end --生成100个10个字符的字符串declare @n int,@m intdeclare @tb table(zfc char(10))declare @zfch varchar(10)set @n=1set @m=1set @zfch=''set nocount onwhile @n<=100begin  while @m<=10   begin      set @zfch=@zfch+(select top 1 zm from  @zmb order by newid())      set @m=@m+1    end insert into @tb values(@zfch) set @zfch='' set @m=1 set @n=@n+1endset nocount offselect  * from @tb

评论