Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, RAND() Rss

   Items 1 to 6 of 6   
 

RANDom traps for the unwary

The Books Online description of the RAND() function is only true from certain perspectives.  Read more...
By David Poole 2016/05/09 | Source: SQLServerCentral.com | Category: rand()
Rating: |  Discuss |   Briefcase | 2,219 reads

Fun with RAND()

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

Random unions

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

How Many Different Random Numbers?

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

RAND Unions

By Steve Jones 2014/09/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,982 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,528 reads
   Items 1 to 6 of 6   
 
Tags
abs() (1)    
checksum() (1)    
data generation (1)    
random dates (1)    
random numbers (1)    
rank() (1)    
test data (1)    
union (1)    
union all (1)