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,149 reads

Fun with RAND()

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

Random unions

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

How Many Different Random Numbers?

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

RAND Unions

By Steve Jones 2014/09/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,973 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,503 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)