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
- 7904 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What are unicode character string data types in ms sql server?
How to create an index on a view?
How to set a database state to offline in ms sql server?
How can you list all the table constraints in a database?
Ms sql server index?
What do you think of this implementation? Can this be implemented better?
Explain system scalar functions?
What are transactions and its controls?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Do you know what are the differences between lost updates and uncommitted dependencies?
Can We Use Data-grids For Our Report In Ssrs?
How to create a simple stored procedure in ms sql server?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Explain DBCC?
