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  

---

What are the steps to insert a table?

0 Answers  

---

What is the SQL?????????????????????????????

5 Answers   CMS,

---

Is truncate autocommit?

0 Answers  

---

What is BLOCK statements in SQL?

0 Answers   HCL,

---

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

Repair mdf file

2 Answers  

---

What is trace flag in sql server?

0 Answers  

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

---

Explain a join?

0 Answers  

---

What methods do you follow to protect from sql injection attack?

0 Answers  

---

What is the difference between row_number and dense_rank?

0 Answers  

---