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  

---

Explain database normalization?

0 Answers  

---

What are the aggregate and scalar functions?

0 Answers  

---

what is IDE,DMV in sql server?

1 Answers   Value Labs,

---

Difference between Inner vs outer joins?

0 Answers  

---

---

What is spatial and temporal data?

0 Answers  

---

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---

how to implement locking in sql server

3 Answers   Satyam,

---

How to recompile stored procedure at run time?

0 Answers  

---

What is surrogate key? : sql server analysis services, ssas

0 Answers  

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

what is sql injection?

2 Answers  

---