Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Random Numbers Rss

   Items 1 to 6 of 6   
 

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,467 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,611 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,835 reads

random integer number scalar function

this produces a random integer between a certain range  Read more...
By Chris Morton 2008/12/12 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |  Briefcase | 723 reads

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 2008/11/13 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |  Briefcase | 2,189 reads

Create Sample Data Script

in this scripts there are two methods of creating sample data for a gambling application. i have used both cursors and loops.  Read more...
By Chris Morton | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |  Briefcase | 406 reads
   Items 1 to 6 of 6   
 
Tags
rand() (2)    
sql server 2005 (2)    
checksum() (1)    
cursors (1)    
data generation (1)    
newid() (1)    
passwords (1)    
scalar-valued functions (1)    
seed values (1)    
sql server 7 (1)    
test data (1)    
t-sql (1)    
while loop (1)