msSql Trigger question (insert and update together)

[darwin101]

Hi all

Is it possiable to write one trigger that handles inserts and updates ?
my table has has 2 fields, Id and Description. When a new record is inserted my trigger does an insert of this record into table B. That works fine.

When a record in table A is updated I want the trigger to update the same record in table B.

I can write 2 triggers to do this but I was wondering if they could be combined and/or what is best practice?

I have not been able to find examples on this in my books or BOL. Did I miss something..

much thanks

 

[vongrunt]

> Is it possiable to write one trigger that handles inserts and updates ?

Yes. Simply create trigger FOR INSERT, UPDATE and then merge logic from two existing triggers into signle one. You can easily determine action (INSERT or UPDATE) by checking inserted/deleted tables.

Is it worth it? I'd say yes - triggers can be ugly, 2-3 small triggers are even uglier.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[darwin101]

thanks, i rolled it up into one trigger.