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

What are the different sql server versions?

984

Tell me what is a linked server?

1040

What is the difference between mysql and mysqli?

1206

How do I setup a sql server database?

1078

What is sql server schema compare? How we can compare two database schemas?

1033

Name some of the open source software that you can use in alternative to SSR?

161

Why is sql server log file full?

1041

What is the data tier application?

169

What are the properties of the transaction?

1006

What is filter index?

952

How to execute function in stored procedure sql server?

1158

How do I uninstall sql server 2014?

940

What happens if you insert a duplicate key for the primary key column in ms sql server?

978

What is failover clustering overview?

1091

what is the difference between delete table and truncate table commands? : Sql server database administration

1040