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  

---

How do I create an extended event in sql server?

0 Answers  

---

What guidelines should be followed to help minimize deadlocks?

0 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

What is function of ROLLUP ?

0 Answers   HCL,

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

What is the openxml statement in sql server?

0 Answers  

---

What are the mathematical functions supported by sql server 2005?

0 Answers  

---

How cand Optimize SQL Server Stored Procedures

1 Answers  

---

what kind of lan types do you know? : Sql server database administration

0 Answers  

---

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

5 Answers   CMS,

---