How to loop through the result set with @@fetch_status?

0 Answers  

---

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,

---

Can sql servers link to other servers?

0 Answers  

---

Explain what are page splits? : SQL Server Architecture

0 Answers  

---

I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

---

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

---

What does the on delete cascade option do?

0 Answers  

---

Which are the important points to note when multilanguage data is stored in a table?

0 Answers  

---

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 Answers  

---

How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,

---

Can group by and orderby be used together?

0 Answers  

---