Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,

---

What are the new security features added in sql server 2012? : sql server security

0 Answers  

---

what is differece between union and union all

6 Answers  

---

How do I port a number to sql server?

0 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

What are tables in sql server?

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,

---

What happens to a statement batch if there is a compilation error?

0 Answers  

---

Define indexes?

0 Answers  

---

Can we use trigger new in before insert?

0 Answers  

---

Tell me the phases a transaction has to undergo?

0 Answers  

---

what is the difference between count(*) and count(1) ?

0 Answers   MCN Solutions,

---