dear u can do like insert into t2 select * from t1 insert into t3 sele

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 / gaurav

4 Answers
7561 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Give me any three differences between Truncate and Delete.

1046

How do you send email on SQL Server?

1003

What is set nocount on?

895

What is query parameter in ssrs?

143

What are clustered and non-clustered index?

950

What are the recovery models in sql server 2000?

927

What is snapshot replication?

1000

How to update multiple rows with one update statement in ms sql server?

1138

What is a primary key?

901

What program is used to store the data source file?

907

How to achieve Paging of records in SQL SERVER?

1037

How to convert a table data in XML format in sql server?

2495

Explain how dts is used to extract, transform and consolidate data?

940

What is store procedure? How do they work?

956

What are the instances when triggers are appropriate?

929