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 different types of backup avaible in SQL SErver

6 Answers   Emphasis, IBM,

---

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,

---

what is the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

Explain sql delete command?

0 Answers  

---

What is isnull() operator?

0 Answers  

---

How to update values in a table with update statements in ms sql server?

0 Answers  

---

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

0 Answers   HCL,

---

Explain cross join or cartesian product in sql?

0 Answers  

---

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 Answers  

---