Re: Create One Trigger For Both Update and Delete

From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 30 Apr 2007 22:10:35 +0200

On 30 Apr 2007 06:02:57 -0700, satish wrote:

hi,
CAn i have one trigger for both Update and Delete

(snip)

Can i have one trigger instead of these Triggers ..

Hi satish,

Yes.

CREATE Trigger [tr_update_delete_user_log]
on [dbo].[user_log] for update, delete
as
begin
insert into z_user_log select * from deleted
end

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.

References:
- Create One Trigger For Both Update and Delete
  - From: satish

Prev by Date: FTP DOWNLOAD! CRACKED SOFTWARE/SOFTWARE CRACKS/DONGLE CRACKS/DONGLE EMULATORS/WAREZ CD/CODES/SERIALS
Previous by thread: Create One Trigger For Both Update and Delete
Next by thread: Replicating database btw two sites why aren't the tables identical in size?
Index(es):
- Date
- Thread

Relevant Pages

Re: nulls
... Hugo Kornelis, SQL Server MVP ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
(comp.databases.ms-sqlserver)
Re: Error in Proc
... Recommended reading: ... Hugo Kornelis, SQL Server MVP ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
(comp.databases.ms-sqlserver)
Re: Rqst for Inventory Database Best Practices
... Hugo Kornelis, SQL Server MVP ... Prev by Date: ...
(comp.databases.ms-sqlserver)
Re: A basic question: Removing duplicate results from Max function
... Here's a third suggestion: ... Hugo Kornelis, SQL Server MVP ...
(comp.databases.ms-sqlserver)
Re: Nested select
... Order column is NOT NULL...) ... Hugo Kornelis, SQL Server MVP ...
(microsoft.public.sqlserver.mseq)