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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-03 : 08:51:58
|
| Donny writes "I need to insert about 6000 records into an SQL table. I've thought of a few ways to do this, but none of them are as fast as I'd like. I first tried to use a loop to assign a batch query to a variable, and then executing just one long batch query. This didn't work because the ASP page took an excessive amount of time to just assign the variable.Then, I tried to simply execute 6000 queries in a loop. This worked, but slowly, and it doesn't seem to effecient. Lastly, I tried to write a stored procedure that would be called on as many times as needed to insert. This method worked fairly better than the one above, in terms of speed, but it locked up the machine that the database was on.Right now, I'm using the 6000 query method. So my question, to you SQL Guru, is how can I insert this much data at one time without slow performance, and repeated queries?Thanks, P.S. I hope this actually wont stump you, as I'd like a solution" |
|
|
|
|
|
|
|
Multiple Inserts