<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
RAND()
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,066 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
|
4,847 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
|
6,590 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
|
4,970 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
|
789 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
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
randomise randomize
Rating:
|
Discuss
|
Briefcase
|
229 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,345 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,066 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)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
