Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

---

List some major differences between triggers and stored procedures?

0 Answers  

---

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

---

What is awe?

0 Answers  

---

What is the guest user account in sql server? What login is it mapped to it? : sql server security

0 Answers  

---

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

---

How secure is sql server database?

0 Answers  

---

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---

Explain the disadvantages/limitation of the cursor?

0 Answers  

---

What are the differences between having and where clause.

0 Answers  

---