create trigger td on jobs for delete as insert testjobs (job_desc,min_lvl,max_lvl,type) select job_desc,min_lvl,max_lvl,1 from deleted gocreate trigger tu on jobs for update as insert testjobs (job_desc,min_lvl,max_lvl,type) select job_desc,min_lvl,max_lvl,2 from inserted go
on jobs
for delete
as
insert testjobs (job_desc,min_lvl,max_lvl,type)
select job_desc,min_lvl,max_lvl,1 from deleted
gocreate trigger tu
on jobs
for update
as
insert testjobs (job_desc,min_lvl,max_lvl,type)
select job_desc,min_lvl,max_lvl,2 from inserted
go