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 8 of 8   
 

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,180 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,054 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,025 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 | 812 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 | 257 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,473 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 8 of 8   
 
Tags
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)    
scalar-valued functions (1)    
seed values (1)    
testing (1)    
t-sql (1)