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..
Answer Posted / 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 |
Post New Answer View All Answers
Define ACID properties in a Database?
What command is used to rename the database?
Introduction of rollup clause using sum and group by clause?
How to set the current database in ms sql server?
You want to implement the one-to-many relationship while designing tables. How would you do it?
How to encrypt data between dialogs?
How to maintain a fill factor in existing indexes?
What is the ‘fillfactor’?
When would you use sql joins?
What are the different index configurations a table can have?
Explain the xml support sql server extends?
What is the difference between value type and reference type?
What is Federation and Federation Member?
Explain go command in sql server?
what are database files and filegroups? : Sql server database administration