SQL Server 2000 - Triggers

Hi,


I need to write a trigger for insert, update and delete. But how do I differentiate the action in the trigger..

I need something like this..



if inserted
begin
insert into user_hist from inserted.......
end
if updated
begin
insert into user_hist from updated....
end
if deleted
begin
insert into user_hist from deleted....
end

I don't think it is possible to have different logic for each type in the one trigger. You can however have more than one trigger on a table each of which can be ( but does not have to be) for a different transaction type.

Loads of info in sql help.

You can differentiate the actions like this

IF SELECT COUNT(*) FROM INSERTED >0
AND SELECT COUNT(*) FROM DELETED >0 THEN

--Your update logic here as during update action both inserted and deleted tables get populated with your new values and old values respectively

ELSE IF SELECT COUNT(*) FROM INSERTED >0 AND SELECT COUNT(*) FROM DELETED =0

--Your Insert logic here as during insert action only INSERTED table will get populated with values you're inserting

ELSE IF IF SELECT COUNT(*) FROM DELETED >0 AND SELECT COUNT(*) FROM INSERTED =0

--Your DELETE logic as during delete action DELETED table alone gets populated