Posted by Hugo Kornelis on 04/30/07 20:10

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

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

[Reply to this message]