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

Content with tag Data Generation Rss

   Items 1 to 5 of 5   

A Simple Formula to Calculate the ISO Week Number

He admits it wasn't his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you're "stuck" with SQL Server 2005 or less, you're going to like this a whole lot!  Read more...
By Jeff Moden 2013/04/08 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,765 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: | Category: test data
Rating: |  Discuss |   Briefcase | 5,393 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: | Category: data generation
Rating: |  Discuss |   Briefcase | 7,399 reads

Data script generator

SP to extract data from a table as a set of INSERT statements.  Read more...
By Jacek Osuchowski 2009/03/11 | Source: | Category: data extraction
Rating: |  Discuss |   Briefcase | 1,576 reads

Create Sample Data Script

in this scripts there are two methods of creating sample data for a gambling application. i have used both cursors and loops.  Read more...
By Chris Morton 2008/10/10 | Source: | Category: cursors
Rating: |  Discuss |   Briefcase | 615 reads
   Items 1 to 5 of 5   
random numbers (3)    
test data (3)    
abs() (2)    
checksum() (2)    
rand() (2)    
t-sql (2)    
cursors (1)    
data extraction (1)    
date calculations (1)    
iso (1)    
iso week (1)    
random dates (1)    
tally table (1)    
while loop (1)