What are the purpose of Normalisation?

0 Answers   HCL,

---

what is a transaction? : Sql server database administration

0 Answers  

---

What is Cross Join

3 Answers  

---

optimization techinques

0 Answers   Wipro,

---

What is amo? : sql server analysis services, ssas

0 Answers  

---

What are types of storage modes? : sql server analysis services, ssas

0 Answers  

---

what is DTS what are tasks available

1 Answers   Wipro,

---

How to change the password of a login name in ms sql server?

0 Answers  

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

How to get the definition of a view out of the sql server?

0 Answers  

---

what is the disadvantage of SQL Loder?

1 Answers   TCS,

---