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

Fun with RAND()

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

Random unions

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

How Many Different Random Numbers?

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

RAND Unions

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