Is SELECT INTO optimal to copy data?
-
I am writing a stored proc. Currently doing a "SELECT INTO" to copy data from one table to a new one. But eventually a. I want to do it most optimally as the data is gonna be huge b. Also it should be able to insert data in an existing table. What SQL stmt/function should I use? :doh: Salil Khedkar [^]
-
I am writing a stored proc. Currently doing a "SELECT INTO" to copy data from one table to a new one. But eventually a. I want to do it most optimally as the data is gonna be huge b. Also it should be able to insert data in an existing table. What SQL stmt/function should I use? :doh: Salil Khedkar [^]
INSERT INTO [table]
SELECT [col1], [col2], [col3], ...
FROM ...Stability. What an interesting concept. -- Chris Maunder -- modified at 8:32 Thursday 2nd February, 2006