Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  

---

What is the difference between nvl and nvl2?

0 Answers  

---

You want to implement the many-to-many relationship while designing tables. How would you do it?

0 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  

---

What is BCNF? How is it better than 2NF & 3NF?

0 Answers   Essar,

---

Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,

---

What is mean by candidate key?

0 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

What is the recommended total size of your memory optimized tables?

0 Answers  

---

What are Row versions of DataRow?

0 Answers  

---

What is difference between join and natural join?

0 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---