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
- 6972 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
What stored by the model?
how can a database be repaired? : Sql server administration
Why truncate is ddl command?
State the difference between union and union all?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
How do I start sql server 2016?
What is difference between aggregate and analytic function?
What does asynchronous call backs means?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
what does the automatic recovery do? : Sql server administration
List out a number of the wants to setup a SQL Server failover cluster?
Do you know the isolation level that sql server support?
What is ssl in sql server?
What is SQL Azure Firewall?
What is statement level trigger?
