insert into T1 select *from t2 union/union all (without duplicates/with

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..

Question Posted / siva

4 Answers
7753 Views
I also Faced
E-Mail Answers

Answer Posted / siva

insert into T1
select *from t2
union/union all (without duplicates/with duplicates )
select *from t3

union/union all
select *from t4
.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is inner join? Explain with an example?

1225

What are the advantages of using stored procedures?

952

what's the difference between a primary key and a unique key? : Sql server database administration

957

Explain a join?

1072

What does truncate do?

943

What is sql server 2000 work load governor?

1071

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1092

between cast and convert which function would you prefer and why?

957

What is cursor in ms sql server?

1153

What is SQL Server?

1219

How to loop through the result set with @@fetch_status?

1351

how can a database be repaired? : Sql server administration

978

Tell me the phases a transaction has to undergo?

964

What is the purpose of sql profiler in sql server?

1022

What is the purpose of indexing?

1046