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

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

drop table tmpTableName

转载于:https://www.cnblogs.com/snlfq2000/archive/2010/11/24/1886942.html