set @BeginNum=0

set @EndNum=500

set @TotalCount=80

set @CurrentRecord=1

While @CurrentRecord<=@TotalCount

Begin

set @Value= @BeginNum+(@EndNum - @BeginNum)*rand()

update [tableName] set [columnName] = @Value where [IDColumnName] = @CurrentRecord

set @CurrentRecord=@CurrentRecord+1

End