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  

---

Do you know what is lock escalation?

0 Answers  

---

What is a job?

3 Answers  

---

What is an indexing technique?

0 Answers  

---

Explain external key management in sql server 2008

0 Answers  

---

What are points to remember while using the fillfactor argument?

0 Answers  

---

What Is Rdbms?

0 Answers   Accenture,

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

What are pages and extents? : SQL Server Architecture

0 Answers  

---

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

0 Answers  

---

How do I view a procedure in sql server?

0 Answers  

---