select 字段 into #aaa from 你的表名
delete from 你的表名
dbcc checkident(你的表名,reseed,0)
insert 你的表名 (字段) select 字段 from #aaa
drop table #aaa
如cloth(cid,clcode,cloth) cid字段为identity(int,1,1) 重建cid
select * into #aa from cloth4
delete from cloth4
dbcc checkident(cloth4,reseed,0)
set IDENTITY_INSERT ON
insert cloth4(clcode,clname) select clcode,clname from #aa
//注意不能选择cid列
drop table #aa