Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jwe
Starting Member
13 Posts |
 Posted - 2007-08-02 : 07:17:19
|
| Hi,Does anyone have an easy method to create random test data for a table?Thanks, |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-02 : 07:32:30
|
Yes.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
jwe
Starting Member
13 Posts |
Posted - 2007-08-02 : 08:52:16
|
| nice to hear. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-02 : 08:58:33
|
| have a table with some data to start withthen you can cross join it itself to get exponential number test data with each cross join._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-02 : 09:00:51
|
Oh, I thought OP meant "random test data" as random numbers, random strings, random dates and so on...
E 12°55'05.25"N 56°04'39.16" |
|
|
|
jwe
Starting Member
13 Posts |
Posted - 2007-08-02 : 09:38:14
|
| thanks guys. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-02 : 09:45:52
|
Don't you think you have to tell us what kind of test data you need, before we can answer you with a solution?As I wrote before, there are many kind of datatypes.And strings, how long can they be? Spaces? Hyphens?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Data generator