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 - 2003-02-14 : 07:33:40
|
| potence writes "HiI have an array which is the result of calculation from text file.I need to convert the array in memory into SQL Server as table.Actually the array is huge; more than 1000 record * 438 attributes.My first solution is to make multiple Insert sentences and execute them.As you know, it's S~~~L~~~O~~~W very much.My second solution is to use "Bulk Insert" which means I have to convert array in memory into text file (in disk).The performance is much better than previous one.But it's not also good solution.Please advance me.Is there special store procedure?Any other idea?Thanks." |
|
|
|
|
|
Bulk Insert from array (in memory) to SQL server