增加自增列并复制为新表
程序员文章站
2022-06-13 16:41:19
...
增加自增列并复制为新表 无 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 OldTable EXEC sp_dboption 'pub','select into/bulkcopy','false'
推荐阅读