Updating a column with random values between specific range?

Question

I have a column where I need to update it's value by random numbers between 1 and 3150 (just being specific)

Can I do this with a simple TSQL statement?

Phil Hunt · Accepted Answer · 2010-11-29 04:12:15Z

2

Use RAND(), re-seeding the function on each call.

UPDATE MyTable
SET MyColumn = 1 + FLOOR(3150 * RAND(CONVERT(varbinary, NEWID())))
WHERE ...

answered Nov 29, 2010 at 4:12

Phil Hunt

8,5711 gold badge33 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CHECKSUM(NEWID()) could be used too to seed RAND