MS-SQL应对主键重复生成增长ID

Select identity(int,1,1) as iid,* into tmpTableName from TableName
Select * from tmpTableName

drop table tmpTableName