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 |
|
Blastrix
Posting Yak Master
208 Posts |
 Posted - 2002-05-13 : 19:39:39
|
| Does anyone know of a script, program, or way to fill a created table with rows upon rows of junk data to test performance? Nothing overly complicated like creating relationships, but just filling inrandomd values for ints, varchars, dates, etc...Thanks,Steve |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-05-13 : 21:08:36
|
| You can use cross joins to create lots of data in a hurry.Also you can do something like:Set x=1While x < 100000 BEGIN INSERT INTO ....... VALUES ...... x=x+1 ENDEND(the syntax may be a little off) |
 |
|
|
|
|
|
I want to fill my tables with junk!