i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..
i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used..
- 4 Answers
- 6423 Views
- I also Faced
- E-Mail Answers
Answer Posted / gaurav
dear u can do like
insert into t2 select * from t1
insert into t3 select * from t2
.
.
.
.
so on
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What are the advantages of mirroring?
What is default port number for sql server 2000?
How to list all dsn entries on your local machine using odbc_data_source()?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is the name of the Database which IBM mainframe uses?
How to drop an existing schema in ms sql server?
Explain linked server in sql?
How can we get count of the number of records in a table?
Tell me about the approaches which you used to counter the DI problems.
How to delete an existing row with delete statements in ms sql server?
What is the index requirement in SQL Azure?
Can group functions be mixed with non-group selection fields in ms sql server?
Do you know what are pages and extents? : SQL Server Architecture
What is a ddl statement?
You want to implement the one-to-many relationship while designing tables. How would you do it?
