Yes, thank you very much 🙂

Just in case anyone else is wondering. Here is my test code:

create table JDBT1 ( a int, b int);

create table JDBT2 ( i int, d int);

go

create trigger tr1 on JDBT1 after insert, update, delete

as

begin

declare @qI int,@qU int,@qD int;

select @qI = count(*) from inserted;

select @qD = count(*) from deleted;

insert into JDBT2 ( i,d) values (@qI, @qD)

end

go

insert into JDBT1 (a,b) values( 1,2);

update JDBT1 set b=3;

delete from JDBT1;

select * from JDBT2;

which gives a nice little result set of

1, 0

1, 1

0, 1

John