去除自增列导数据

truncate table Table
go

set identity_insert Table on

 

insert into Table
select  from Table1

 

set identity_insert Table off