前沿拓展:
delete語(yǔ)句
B
我有一些數(shù)據(jù),想要?jiǎng)h除,第一想到的是delete,但是它會(huì)保留之前的標(biāo)識(shí),后來(lái)想用truncate來(lái)進(jìn)行刪除,但是,它會(huì)全部刪除,并且不能加條件,只能回過(guò)頭使用delete,以下是解決delete刪除不保留之前的標(biāo)識(shí)值
delete from Emplyoee where EmplyoeeId between 19 and 31
DBCC CHECKIDENT ('dbo.Emplyoee',reseed, 7)—標(biāo)識(shí)從8開(kāi)始
insert into Emplyoee values('cc','男','1996-10-01',201,5500,'湖北十堰','**')
insert into Emplyoee values('cc1','男','1996-10-01',201,5500,'湖北十堰','**')
insert into Emplyoee values('cc2','男','1996-10-01',201,5500,'湖北十堰','**')select * from Emplyoee
ok,解決了!
拓展知識(shí):
原創(chuàng)文章,作者:九賢生活小編,如若轉(zhuǎn)載,請(qǐng)注明出處:http:///59360.html