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

Who is the owner of a schema in ms sql server?

1116

Tell about MOM Tool(Microsoft Operator Manager)?

1959

What do you understand by hotfixes and patches in sql server?

1031

What are indexes in ms sql server?

1115

What is an execution plan? When would you use it?

1026

Where is trigger in sql server?

1104

How you provide security to cube? : sql server analysis services, ssas

1009

How to write a query with a right outer join in ms sql server?

961

What is difference between stored procedure and user defined function?

1170

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1122

What are the restrictions applicable while creating views? : SQL Server Architecture

1084

What is ms sql server index?

1149

How many types of the database links?

1116

How can you insert null values in a column while inserting the data?

1343

Explain about protocol layer present in SQL server?

1292