摘要:
方法一、 1、查询出重复的数据,Id只保留其中一个 SELECT MIN(Id) Id,Name FROM dbo.City GROUP BY Name HAVING COUNT(1) > 1 2、然后使用删除时Join上面的表 DELETE C FROM City C JOIN ( SELECT 阅读全文
摘要:
using Maticsoft.Common; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace Matics... 阅读全文