笔架峰

先在表中加一字段RID设为主键自动编号后执行下列语句delete from Table where RID not in (select avg(RID) from Table group by ID)ID为重原表的重复ID 

 客户要求用信任连接连数据库，所以将用sa连接方法：server=机器名;uid=sa;pwd=密码;database=数据库名;改成：workstation id=机器名;packet size=4096;integrated security=SSPI;data source=机器名;persist security info=False;initial catalog=数据库名称