"how to populate a database column with random numbers" Code Answer

i suppose you could make the column a primary key to prevent duplicates, though that's kind of a hack. you can remove the key later.

---- create the variables for the random number generation
declare @random int;
declare @upper int;
declare @lower int;
declare @index integer

---- this will create a random number between 1 and 999
set @lower = 1 ---- the lowest random number
set @upper = 999 ---- the highest random number
set @index = 0 --- a while loop counter

--- loop from 0 to 10
while @index < 10
begin
  select 'loop counter = ', @index
  select @random = round(((@upper - @lower -1) * rand() + @lower), 0)
  --insert @random here.
  set @index = @index + 1
end

By khajlkdk-b1211156f8f2 on May 19 2022