Tag Archives: random

Select random value from a range of values

Posted on 01/02/2010 by Eric Fickes

Earlier I blogged about creating random numbers using tsql functions.  Here are two techniques for selecting a random value from a pre-defined range of values in a tsql script.  The first technique uses a table variable ( MSSQL 2000 + … Continue reading →

Posted in database, development, microsoft, tips and tricks, tsql | Tagged , , , , , , , , | 1 Comment

Generate random integers using tsql UDFs

Posted on 09/02/2009 by Eric Fickes

Ever need to generate random numbers from the integer family?  I had this need on a project so I whipped up these four tsql User Defined Functions to help with this task.  There are four functions in all, one for … Continue reading →

Posted in database, development, microsoft, SQL, tsql | Tagged , , , , , , , , , | 4 Comments