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
- 6971 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
Explain different types of self contained sub query?
How to define and use table alias names in ms sql server?
Explain the difference between function and stored procedure?
How to retrieve field values using mssql_result()?
How to rename an existing column with sql server management studio?
Explain the use of containers in ssis and also their types?
What happens when unicode strings concatenate with non-unicode strings?
Do you know what is xpath?
Call by value and call by reference in procedure and function, with NOCOPY.
Is sql different from sql server?
How to use clusters?
How adventureworkslt tables are related?
Explain how to use linked server?
What is postgresql server?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
