如果非要用标识就要先用:
create trigger tr_partNo on partNo
for delete
as
select * from deleted
if @@rowcount>0
begin
declare @partNoID int
select @partNoID=max(partNoID) from partNO
//或用 select @partNoID=partNOID from deleted
dbcc checkident(PartNoID,reseed,@partNoID)
end