1.在此表中添加一个名为UniqueResourceId
的IDENTITY列 2.执行此查询

1. Add an IDENTITY column to this table called UniqueResourceId
2. Execute this query

DELETE FROM  Resource_Master WHERE UniqueResourceId NOT IN (
SELECT MIN(UniqueResourceId) FROM Resource_Master GROUP BY ResourceId, ResourceName, ResourceDesc, ResourceKey)

3.现在，如果要通过Google搜索

3. Now drop the UniqueResourceId column

= ie7& rls = com.microsoft:en-gb:IE-Address& ie =& oe => this [如何从SQL Server中的表中删除重复的行 [

If you would have googled for this[^], the very first article would have helped you.

Anyways, look at this article.

How to remove duplicate rows from a table in SQL Server[^]