SQLServerCentral: Content tagged Random Numbers

Generate a random password

If you ever need a quick way to generate random passwords, this is a pretty useful way to do so. Read more...

By Gaby Abed 2013/05/15 | Source: SQLServerCentral.com | Category: random numbers

Rating:

|

Discuss |

Briefcase | 3,104 reads

Generating Test Data: Part 2 - Generating Sequential and Random Dates

Part two of this fantastic series from Jeff Moden looks at generating date data, something which can be handy for any number of testing purposes. Read more...

By Jeff Moden 2012/04/25 | Source: SQLServerCentral.com | Category: test data

Rating:

|

Discuss |

Briefcase | 4,850 reads

Generating Test Data: Part 1 - Generating Random Integers and Floats

Learn how you can easily generate large amounts of test data efficiently in this new series from Jeff Moden. Part 1 covers integers and floating point values. Read more...

By Jeff Moden 2012/03/26 | Source: SQLServerCentral.com | Category: data generation

Rating:

|

Discuss |

Briefcase | 6,591 reads

Finding Unique Non-Repeating Random Numbers

Learn three methods of creating random numbers that do not repeat in this article from Brandie Tarvin. Read more...

By Brandie Tarvin 2010/08/12 | Source: SQLServerCentral.com | Category: sql server 2005

Rating:

|

Discuss |

Briefcase | 7,573 reads

Quickly Generate Random number by TSQL with 99.9% Uniqueness Guarntee

Here is the simplest and most efficient technique to guarantee the uniqueness of random numbers. Read more...

By Namwar Rizvi 2009/09/17 | Source: SQLServerCentral.com | Category: random numbers

Rating:

|

Discuss |

Briefcase | 1,889 reads

Random problems

Building random numbers can be challenging for people working in T-SQL. New author Chris Nowicki brings a solution he used to get a random number assigned to each row of a result set. Read more...

By Chris Nowicki 2009/06/09 | Source: SQLServerCentral.com | Category: random numbers

Rating:

|

Discuss |

Briefcase | 4,970 reads