go
if object_id('tri_tracy')is not null
drop trigger tri_tracy
go
create trigger tri_tracy on A
for insert
as
if exists(select 1 from inserted)
   and not exists(select 1 from deleted)
begin
insert B
select a,b,cast(ceiling(rand()*100000) as int),getdate() from inserted
end