QUESTION?: Swapping Table :QUESTION?

QUESTION?: Swapping Table :QUESTION?

Post by Anurag Shar » Sat, 18 Apr 1998 04:00:00



Hi,
   Is it possible in SQL Server 6.5 to swap an already existing table
in a database with a new table?. Both the table names are the same and
both the table structures are the same.

   Therefore, I am essentially trying to only swap data between the two
tables.

Thank You.
                                                            Regards,
                                                            Anurag

 
 
 

QUESTION?: Swapping Table :QUESTION?

Post by Anurag Shar » Sat, 18 Apr 1998 04:00:00


Hi,
   Is it possible in SQL Server 6.5 to swap an already existing table
in a database with a new table?. Both the table names are the same and
both the table structures are the same.

   Therefore, I am essentially trying to only swap data between the two
tables.

Thank You.
                                                            Regards,
                                                            Anurag

 
 
 

1. QUESTION?: Swapping Table :QUESTION?

Hi,
   Is it possible in SQL Server 6.5 to swap an already existing table
in a database with a new table?. Both the table names are the same and
both the table structures are the same.

   Therefore, I am essentially trying to only swap data between the two
tables.

Thank You.
                                                            Regards,
                                                            Anurag

2. Save time in hh:mm:ss AM/PM format

3. joining 3 tables with same field names

4. Hot swap new database for old - Questions

5. Recommended Oracle Text

6. can swap e-mail question NOW?

7. rs.sort - syntax to use querystring variable - asp page

8. Question : gotcha's in upgrading by swapping system drives

9. Informix & Swap Space Question (DEC Unix)

10. newB question: related tables question

11. Questions, questions and more questions...

12. Q: How to swap two tables?