Answer / mohamed idhris

SET ROWCOUNT 1

DELETE FROM tbl_name WHERE field_name= 'field_value'

SET ROWCOUNT 0


the above query will delete the duplicate row

Answer / rakesh pattajoshi

delete from tbl where id not in(select max(id) from tbl group by name)

Answer / priya

use distinct.it removes the duplicate rows

Answer / ranjitha

Add Primary Key to the table.

Explain dma? : Dot net architecture

0 Answers  

---

When do I need to use gc.keepalive?

0 Answers  

---

Let's say I have an existing application written using Visual Studio 6 (VB 6, InterDev 6) and this application utilizes Windows 2000 COM+ transaction services. How would you approach migrating this application to .NET ?

1 Answers  

---

if there are two application 1 and 2 having a variable x in both app if client1 changes value of x in 1 app client 2 want reads the value of x from 2 app what resultant value will he get

0 Answers   PCS,

---

How do I stop a thread?

0 Answers  

---

Explain about clr?

0 Answers  

---

What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?

2 Answers  

---

what is polymorphism and advantage ?

0 Answers   TCS,

---

Explain the purpose of cache? How is it used? : .NET Architecture

0 Answers  

---

can aspx page contains two pager tags ?

1 Answers  

---

What is the difference between a web custom control,web user control and a web part.

1 Answers   247Customer,

---

How to call the dll at runtime in .Net?

4 Answers   iGate, Infosys,

---