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..
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
Can we call future method from trigger?
Do you know what are different types of replication in sql server?
Explain about link server in sql server?
What are the different normalization forms?
What are relationships and mention different types of relationships in the dbms
What is the full meaning of dml?
How can I get data from a database on another server?
Which command is used for user defined error messages?
What number aggregate functions are accessible there in sql?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
how can u get last observation in an unknown dataset ?
What is raid? : SQL Server Architecture
how would you store your query in an SSRS report or a Database server?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Explain sql server service broker?