declare @ID int = 10000
while @ID < 10010
begin
    declare @location varchar(1000) = ''
    declare @i int = 0
    while @i<1000
    begin  
        set @location = @location + char(33 + cast(ceiling(rand() * 80) as int))
        set @i = @i+1
    end
    
    select @location
    set @ID = @ID +1
end

SQL make random string

SQL