New columns or new table alltogether? - TechRepublic
General discussion
August 21, 2002 at 04:31 PM
steiakakis

New columns or new table alltogether?

by steiakakis . Updated 23 years, 7 months ago

In a project I work in we have an SQL Server database full of data (meaning thousands of rows). The need for new columns however has appeared. So far we are inserting new columns one by one via our C++ framework (using insertcolumn e.t.c). Would it be more efficient to create a temp table to store the data, create a new table with all the extra rows needed and then transfer all the data to the new table?
We are using SQL server 2000 over windows 2000.

Thank you

This discussion is locked

All Comments