復制代碼 代碼如下:

create table test_del( a int identity,b char(10))
go
insert into test_del select 'row 1';
insert into test_del select 'row 2';
insert into test_del select 'row 3';
insert into test_del select 'row 4';
insert into test_del select 'row 5';
go

復制代碼 代碼如下:

delete test_del where a = 3
go

復制代碼 代碼如下: