增加自增列并复制为新表 无 exec sp_dboption 'pub','select into/bulkcopy','true'select id=identity(int,1,1),oldtable.* into newtable from oldtableexec sp_dboption 'pub','select into/bulkcopy','false'
增加自增列并复制为新表
exec sp_dboption 'pub','select into/bulkcopy','true'select id=identity(int,1,1),oldtable.* into newtable from oldtableexec sp_dboption 'pub','select into/bulkcopy','false'