damoshayu.cn,苍井空浴缸大战猛男120分钟,网址你懂的,中国女人内射6XXXXXWWW

delete語(yǔ)句(delete語(yǔ)句怎么寫)

前沿拓展:

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語(yǔ)句(delete語(yǔ)句怎么寫)

delete from Emplyoee where EmplyoeeId between 19 and 31

delete語(yǔ)句(delete語(yǔ)句怎么寫)

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

delete語(yǔ)句(delete語(yǔ)句怎么寫)

ok,解決了!

拓展知識(shí):

原創(chuàng)文章,作者:九賢生活小編,如若轉(zhuǎn)載,請(qǐng)注明出處:http:///59360.html