SQLServerCentral.com Scripts tagged RAND()

random randomise randomize data query

Wed, 19 Nov 2008 14:02:19 UT

this is a MUCH simpler method of random randomize randomise rand data from a table

random integer number scalar function

Fri, 12 Dec 2008 07:00:00 UT

this produces a random integer between a certain range

Random DEFAULT string for a column using CASE and NEWID

Thu, 14 Jun 2012 06:00:00 UT

Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.