How to check duplicate save record in sql server

Using common table expression find duplicate value from your table and remove duplicate value from your table.

 

Just change table name and field in this script.

 ----------------------------------------------------------------------------------------------------

 

;WITH CTE (Name,duplicatecount)
AS
(
SELECT Name,ROW_NUMBER() OVER (PARTITION BY Name ORDER BY Name
) AS duplicatecount FROM YourTable
)
-- for show which field is duplicate from table
SELECT * FROM CTE WHERE duplicatecount > 1

-- remove duplicate field from table
--DELETE FROM CTE WHERE duplicatecount > 1 

 

 ----------------------------------------------------------------------------------------------------

Try this