create trigger tr_name on ta for insert as begin insert into a_log select * from inserted end go
create trigger tr_name1 on ta for insert as begin insert into a_log select *,'I' from inserted end go create trigger tr_name2 on ta for update as begin insert into a_log select *,'U' from inserted end go create trigger tr_name3 on ta for delete as begin insert into a_log select *,'D' from deleted end go
on ta
for insert
as
begin
insert into a_log select * from inserted
end
go
on ta
for insert
as
begin
insert into a_log select *,'I' from inserted
end
go create trigger tr_name2
on ta
for update
as
begin
insert into a_log select *,'U' from inserted
end
go create trigger tr_name3
on ta
for delete
as
begin
insert into a_log select *,'D' from deleted
end
go