Posted by satish on 04/30/07 13:02

hi,
CAn i have one trigger for both Update and Delete
Delete Trigger
---------------------
create Trigger [tr_delete_user_log]
on [dbo].[user_log] for delete
as
begin
insert into z_user_log select * from deleted
end

Trigger Update
---------------------
CREATE Trigger [tr_update_user_log]
on [dbo].[user_log] for update
as
begin
insert into z_user_log select * from deleted
end

Can i have one trigger instead of these Triggers ..

• Next in forum: Replicating database btw two sites why aren't the tables identical in size?
• Prev in forum: Yellowfin Version 3.2
• Thread view: Create One Trigger For Both Update and Delete

[Reply to this message]