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
- 7547 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 the different topologies in which replication can be configured?
How to select an exiting database using mssql_select_db()?
What Are the Main Features of SQL Azure?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How to use transact-sql statements to access the database engine?
How to execute stored procedure and set temp table in sql server?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Do you have any idea about the tcl commands?
What does the on delete cascade option do?
How do you send email on SQL Server?
What sql server means?
Explain indexed views?
Tell me about the approaches which you used to counter the DI problems.
How many partitions a clustered index has by default in sql server 2012?
Do you know what are acid properties of transaction?
