Fastest way to copy table in SQLServer 2000
-
Let's presume I have Table1 and Table2 already created and with same strucuture. Table1 has all data. So is this fastest way to copy data: INSERT INTO Table2 SELECT * FROM Table1 ? Tnx
-
Let's presume I have Table1 and Table2 already created and with same strucuture. Table1 has all data. So is this fastest way to copy data: INSERT INTO Table2 SELECT * FROM Table1 ? Tnx
I think this is the fastest. You can try comparing the performance with SELECT * INTO Table2 FROM Table1 Live Life King Size Alomgir Miah
-
Let's presume I have Table1 and Table2 already created and with same strucuture. Table1 has all data. So is this fastest way to copy data: INSERT INTO Table2 SELECT * FROM Table1 ? Tnx
If they are in the same database this should be the fastest or close to it. If you have the transaction log configured to not log it, then using SELECT * INTO Table2 will create table2 and won't be logged which is faster.
I can imagine the sinking feeling one would have after ordering my book, only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon