Previous Topic

Next Topic

Inhoudsopgave

Book Index

ROWCOUNT

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