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

Why normalization is used?

990

How to convert binary strings into integers in ms sql server?

1002

How many databases Microsoft SQL server provides?

1065

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

998

What are the various editions of sql server 2017 that are available in the market?

878

What are the types of sql server?

1031

How to make conditional sum in ssrs?

177

What samples and sample databases are provided by microsoft?

1022

What is partitioned view?

884

What is self join in sql server joins?

1024

What are scalar functions?

980

Explain what is the use of custom fields in report?

895

Why variables called the most powerful component of ssis?

1055

Explain the difference between function and stored procedure?

925

Why do we use trigger?

948