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

Content with tag RAND() Rss

   Items 1 to 12 of 12   
 

Fun with RAND()

By Dave 2014/11/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,809 reads

Random unions

By Steve Jones 2014/10/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,886 reads

How Many Different Random Numbers?

By Amit Goswami 2014/09/30 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,769 reads

RAND Unions

By Steve Jones 2014/09/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,854 reads

Random DEFAULT string for a column using CASE and NEWID

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.  Read more...
By Bill Leung 2012/06/14 | Source: SQLServerCentral.com | Category: random
Rating: |  Discuss |   Briefcase | 1,084 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 | 5,234 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 | 7,134 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 | 5,034 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 | 817 reads

random randomise randomize data query

this is a MUCH simpler method of random randomize randomise rand data from a table  Read more...
By Chris Morton 2008/11/19 | Source: SQLServerCentral.com | Category: randomise randomize
Rating: |  Discuss |   Briefcase | 259 reads

Predictable Index Fragmentation

This technical article provides an overview of how to produce specific levels of index fragmentation. Useful for creating test plans.  Read more...
By Craig Outcalt 2008/10/29 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,484 reads

Random DEFAULT string for a column using CASE and NEWID

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.  Read more...
By Bill Leung 2012/06/14 | Source: SQLServerCentral.com | Category: random
Rating: |  Discuss |   Briefcase | 1,084 reads
   Items 1 to 12 of 12   
 
Tags
t-sql (5)    
random numbers (4)    
checksum() (3)    
newid() (3)    
abs() (2)    
data generation (2)    
test data (2)    
case (1)    
default (1)    
fragmentation (1)    
indexing (1)    
random (1)    
random dates (1)    
randomise randomize (1)    
rank() (1)    
scalar-valued functions (1)    
seed values (1)    
testing (1)    
union (1)    
union all (1)