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 |
|
cmspot
Starting Member
44 Posts |
 Posted - 2007-10-18 : 01:56:49
|
| Hello everybody again.Your valueable help is going to be useful for me once again.I think my request is a little bit hard this time.Maybe only for my head.This is what i Want.I want to test the performance of my application using big amount of data so i need something that will fill my tables with random rows.Is there anything?f.e My customers table:Custid IdentityCustLName QWERTYCustFname ASDFGH................Thank you very much for your precious time.I sell my mother in law.Is anybody interested? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-10-18 : 06:04:51
|
| I usually write queries to do it using rand()You probably don't want just random data but would include a weighting to give a bias towards some values.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-18 : 06:31:54
|
To get CHAR/VARCHAR values, you can trySELECT CONVERT(CHAR(36), NEWID())
E 12°55'05.25"N 56°04'39.16" |
|
|
|
cmspot
Starting Member
44 Posts |
Posted - 2007-10-18 : 10:23:55
|
| Thank you Guys!You are a real helpI sell my mother in law.Is anybody interested? |
|
|
|
|
|
|
Sorry!Tough request (At least for me!)