增加自增列并复制为新表

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

EXEC sp_dboption 'pub','select into/bulkcopy','true'
SELECT ID=IDENTITY(int,1,1),OldTable.* INTO NewTable FROM OldTable
EXEC sp_dboption 'pub','select into/bulkcopy','false'