What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

How to change the ownership of a schema in ms sql server?

0 Answers  

---

What is compound operators?

0 Answers  

---

Explain the truncate command? : SQL Server Architecture

0 Answers  

---

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

---

---

How many levels of sp nesting are possible?

0 Answers  

---

What is a select query statement in ms sql server?

0 Answers  

---

difference between truncate, delete aur drop?

2 Answers  

---

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

---

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

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  

---

Is there any difference between primary key and unique with the not null condition?

0 Answers  

---