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
7560 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 the difference between Clustered and Non-Clustered Index?

1014

what is an index? : Sql server database administration

935

How to create view in stored procedure sql server?

960

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1930

What is the use of custom fields in report?

948

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

982

Ways to improve the performance of a SQL Azure Database?

123

How to delete a database in ms sql server?

1120

What are ddl (data definition language) statements for tables in ms sql server?

1029

Which trace flags are enabled in sql server?

943

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1000

How you can add messages to the nt event log from within a stored procedure?

998

What is outer join in sql server joins?

1048

What is 3nf normalization form?

1025

Where can you find the error log information? : sql server database administration

972