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 |
|
bigjt11
Starting Member
2 Posts |
 Posted - 2006-01-12 : 10:43:00
|
| helloi have just created a test database and now need to insert a large number of records into one of the tables, we were thinking of about 1 million records, has anyone got an sql script that i could use to create these recordscheersjohn |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-01-12 : 10:47:33
|
| from where are you inserting these records..? from a text file or another table..? |
 |
|
|
bigjt11
Starting Member
2 Posts |
Posted - 2006-01-12 : 11:11:47
|
| looking to use a text file |
|
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-01-12 : 11:31:34
|
| look for BULK INSERT in sql server books online |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-12 : 13:35:34
|
| Just to clarify:Are you wanting to generate random, but appropriate, data? or to import some real/existing data from an external source [such as a "text" file]?Kristen |
|
|
|
avmreddy17
Posting Yak Master
180 Posts |
Posted - 2006-01-12 : 16:28:32
|
| BCP or BULK INSERT would be fast.....Once you do this back up the database .... |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
inserting large amount of data