cooljagadeesh (3/27/2014)
which way is the better for 1 million records inserting into one table1) insert into destination
select * from source
2) BULK INSERT destination
FROM '\\computer\source.txt';
3) BCP
Quick questions; is this a one off thing? Does it need to be managed, logged, reported? Are all files in the same format? Is speed more important than server load? :w00t: Or is there a file in the first place? Is it maybe a table to table load? 😎
The options you list imply both table and file source.