When we should use @@error?

0 Answers  

---

what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

How to use linked server?

0 Answers  

---

what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

---

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,

---

What are the different types of sub-queries?

0 Answers  

---

What is 'Join' and explain its various types.

0 Answers   Genpact,

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

What stored by the model?

0 Answers  

---

Can you please explain the difference between primary keys and foreign keys?

0 Answers  

---

one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  

---