How to delete the duplicate records in a table using sql
server
Answer Posted / 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
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to improve the cache performance? : .NET Architecture
What is a managed code is dim fs as filestreamobject is a managed code? : .NET Architecture
What is .net mobile lists. : Microsoft dot net mobile
State and explain about microsoft.net?
What is an asssembly qualified name? Is it a filename? How is it different?
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
What is the use of TPL DATAFLOW?
How do I prevent concurrent access to my data?
I am working with asp.net 2005 and Crystal report 10. I have an image field on my dataset to show on Crystal report.And the image is shows dynamically from database in image field of CR. The image field is showing well on my Crystal report on its first page with all other data but when i click to open second page of CR,it does not show any data on that.I found that this is because of adding the image field on crystal report. Because when i remove the image field from the CR then it will run both the pages of CR. I am using the Page Load event to bind CR data with Database. And i have already check with the Init event to bind CR , but it still not shows the data on second page when i use image field on that. Please give solution for that.....
What is the purpose of hard disk? : Dot net architecture
how to make and display a form without title bar?
What is textview control of .net mobile? : Microsoft dot net mobile
Explain domestic architecture artifacts? : .NET Architecture
what is inheritancy where u required ?
what is polymorphism and advantage ?