:) Bye Arun Hi, You can find methods summarized with samples at the article named "How to delete duplicate records or rows among identical rows in a table where no primary key exists" at Hi, You can find methods summarized with samples at the article named "How to delete duplicate records or rows among identical rows in a table where no primary key exists" at only remove duplicate records, select duplicated fields, and then apply group by create table #temp same schema INSERT INTO #temp SELECT field1,field2,field FROM yourtable GROUP BY field1,field2,field DELETE OLDdata INSERT INTO yourtable select * from #temp DROP #temp recommend: in transaction :) I have a table named "delivery" that has 10 fields. U_F and a.transaction_mode='some string/number'); 'some string/number' represent the value that determines which records will be deleted!! Mail me if you find this difficult and wanna get into more details!!All project learners please show your interest for this free SAP session by Faisal Majid.
In this chapter, you learn how to use the Validation Web controls to validate the information that a user enters into an HTML form.
You can use the Validation controls to perform very different types of form validation tasks.
Avoid Duplicate record insert on page refresh using ASP.
NET One of most common issue which many of the web developers face in their web applications, is that the duplicate records are inserted to the Database on page refresh.
But suppose instead of removing all duplicate rows from table, we only want to remove the duplicate entry of a particular employee.