Create One Trigger For Both Update and Delete
- From: satish <satishkumar.gourabathina@xxxxxxxxx>
- Date: 30 Apr 2007 06:02:57 -0700
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 ..
.
- Follow-Ups:
- Re: Create One Trigger For Both Update and Delete
- From: Hugo Kornelis
- Re: Create One Trigger For Both Update and Delete
- Prev by Date: Yellowfin Version 3.2
- Next by Date: Replicating database btw two sites why aren't the tables identical in size?
- Previous by thread: Yellowfin Version 3.2
- Next by thread: Re: Create One Trigger For Both Update and Delete
- Index(es):