不显示删除回复显示所有回复显示星级回复显示得分回复 如何用SQL语句快速有效的为大数据表设置主键及自增

create table newtablename(id [int] IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED ,oldothercolumnlist)
go
insert into newtablename(oldothercolumnlist) select * from oldtable
go