troubleshooting Question
Copy Table in SQL2000
I am new to SQL. and this was in place when I started here.
I have a sql2000 database. It is opened with SQL Server manager 2005.
I have a table that needs to be archived every so often. The table is called TEST.
I need to copy the entire table ( data and columns) to a table called TEST01. Then need to erase all data in TEST so it is empty.
Should I rename TEST to TEST01 then copy the table structure to a new table call TEST?
How can I do this and what commands would it be.
I have a sql2000 database. It is opened with SQL Server manager 2005.
I have a table that needs to be archived every so often. The table is called TEST.
I need to copy the entire table ( data and columns) to a table called TEST01. Then need to erase all data in TEST so it is empty.
Should I rename TEST to TEST01 then copy the table structure to a new table call TEST?
How can I do this and what commands would it be.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.