ever wonder how to make an update trigger? Me neither. I avoid triggers like they are the plague, but sometimes you have to do what you have to do.
The sample below is actually from the great community on twitter. #SQLHelp
is a great resource there. And because we all need to share I submit to you the same sample code. I hope it helps as much as it helped me. Special thanks to @m82labs on twitter
CREATE TRIGGER [MyTrigger]
SET [SomeOtherColumn] = 'SomeValue'
WHERE [MyTable].[PKColumn] = [Inserted].[PKColumn]