Truncate和delete
insert into [dbo].testdroptruncate values (1) select * from testdroptruncate delete testdroptruncate truncate table testdroptruncate
truncate重新记录Identity数
delete继续当前的Identity数
insert into [dbo].testdroptruncate values (1) select * from testdroptruncate delete testdroptruncate truncate table testdroptruncate
truncate重新记录Identity数
delete继续当前的Identity数