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 - 2005-09-30 : 07:30:19
|
| Roisin writes "Can you use Bulk insert - either bcp, bulk insert sql or the dts task, to quickly load data from one table to another?I have to move 1,000,000 records into a temp table, and it's taking up to 5 mins to do - it needs to be quicker.ThanksRoisin" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-30 : 07:32:37
|
| Did you try this?Insert into Table1(columns) Select columns from Table2MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Bulk Insert for SQL