;with a as ( select 1 as id1 ,2 as id2 union all select id1+1,id2+1 from a where id1<=10000000 ) select * into test6 from a option(maxrecursion 0)
解决：高版本
或者修改重复值的数据
sql server新增自增列有重复值（2005 9.0.1399）
原文：https://www.cnblogs.com/gered/p/13158826.html