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..
Answers were Sorted based on User's Feedback
Answer / deepak
Just copy all data in T1 from T4.
insert into T1 (select * from T4)
Now do this assuming 'dateCol' contains the date:
delete from T4
insert into T4 (select * from T3)
delete from T3
insert into T3 (select * from T2)
delete from T2
insert into T2 (select * from T1 where year(dateCol) = 2002)
delete from T1 where year(dateCol) = 2002
This should move the data around without using temp table.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / madhu sudhan g
Hiii
DELETE T1
OUTPUT DELETED.COLUMN1,DELETED.COLUMN2...
INTO T2
DELETE T2
OUTPUT DELETED.COLUMN1,DELETED.COLUMN2...
INTO T3
DELETE T3
OUTPUT DELETED.COLUMN1,DELETED.COLUMN2...
INTO T4
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / 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 |
How do I delete a sql server database?
What is normalization and its types?
Can we call stored procedure in trigger?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What do I need to start working with sql studio? : sql server management studio
What are the restrictions that views have to follow? : SQL Server Architecture
What is a job?
What is raid, and how it can influence database performance?
What are Magic Table?
34 Answers 3i Infotech, Digiweb, Evalueserve, NIIT, PL,
Can we shrink data file in sql server?
What is trigger explain with program?
Why do we use functions?