create table temp(id int identity(0,1),name varchar(20)) insert into temp(name) values('a') insert into temp(name) values('b') insert into temp(name) values('c') select * from temp id name 0 a 1 b 2 c delete tempinsert into temp(name) values('a') insert into temp(name) values('b') insert into temp(name) values('c') id name 3 a 4 b 5 c truncate table tempinsert into temp(name) values('a') insert into temp(name) values('b') insert into temp(name) values('c') select * from temp id name 0 a 1 b 2 c
--执行
truncate table [你的表名]--注意:这个语句会删除你的表所有数据的,小心
insert into temp(name) values('a')
insert into temp(name) values('b')
insert into temp(name) values('c')
select * from temp
id name
0 a
1 b
2 c
delete tempinsert into temp(name) values('a')
insert into temp(name) values('b')
insert into temp(name) values('c')
id name
3 a
4 b
5 c
truncate table tempinsert into temp(name) values('a')
insert into temp(name) values('b')
insert into temp(name) values('c')
select * from temp
id name
0 a
1 b
2 c