Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 4 Answers
- 7553 Views
- I also Faced
- E-Mail Answers
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
How to provide default values to stored procedure parameters?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What will be the maximum number of indexes per table?
What is cached report?
Can you get second highest salary from the table?
Explain in brief how sql server enhances scalability of the database system?
In how many ways you can invoke ssrs reports?
How do you improve the performance of a SQL Azure Database?
Are connections to sql server encrypted?
What is faster join or union?
Explain the properties of the relational tables?
What are recommended options to be used while using db mirroring? : sql server database administration
What are built in functions?
Does partitioning help performance?
What is query and its types?
