>Random numbers in SQL Server

>

I’m putting this here for my future reference.

I sometimes need to generate random numbers (especially when creating test data in a table). Here’s a method to generate random values that will work even when used in a set-based action (ie. inserting records into table B using table A as the source).

select RAND(CHECKSUM(NEWID())) * [upper limit]

where [upper limit] is the maximum number you want in your random set.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s