Open

How do I Update a SQL Column with Random Numbers within a Range 1 - 10

There is a RAND() function in TSQL but this function will generate a random number between 1 and 0 (a floating-point number).....

The below script can generate a random number based on the range of yours

Declare @maxRandomValue int

, @minRandomValue int ;

set @maxRandomValue = 1000

set @minRandomValue = 0

Select Cast( ( (@maxRandomValue + 1) - @minRandomValue)

* Rand() + @minRandomValue As int) As 'randomNumber'

now coming to the update query of yours, the below one is untested but give it a try...

Declare @maxRandomValue int

, @minRandomValue int ;

set @maxRandomValue = 1000

set @minRandomValue = 0

update <table> set <your_column> = Cast( ( (@maxRandomValue + 1) - @minRandomValue)

* Rand() + @minRandomValue As int) As 'randomNumber'