create table
T (i int
not null);
insert into
T values
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
go
/* Deprecated construction */
set rowcount
1;
select
* from T order by
i;
set rowcount
0;
begin tran;
set rowcount
5;
delete from
T;
set rowcount
0;
select * from
T;
rollback tran
;
go
/* Solution */
select top (1)
* from T order by
i;
begin tran
;
delete top
(5) from
T;
select
* from
T;
rollback tran
;
go
drop table
T;
go