然后在表上创建 ignore_dup_key 索引,如下:
CREATE UNIQUE INDEX removedupsON #table_copy (name)WITH IGNORE_DUP_KEY
然后在导入原表数据,简单吧