How do you make a trace?

0 Answers  

---

How do I find information about the install locations for the various instances running on a computer?

0 Answers  

---

What is for xml in sql server?

0 Answers  

---

explain different types of cursors? : Sql server database administration

0 Answers  

---

Why do we need different type of parameter?

0 Answers  

---

---

What is #temp and @table variable in SQL server?

0 Answers  

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 Answers  

---

Explain about Joins?

0 Answers   Infosys,

---

Explain primary key and foreign key constraints?

0 Answers  

---

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

---

What is indexed views? plz explain with example?

2 Answers  

---

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  

---