I would like the following statement to run for each insert,update whether or not it was a multiple update or a single update or a single insert.
I want to trigger whenever the field "Price" is modified or written to.
This is as far as I have gotten on the code which is not all of the way done yet as I dont have it far enough along to then do the insert or update statment.
How can I turn this into a working trigger that will work even if there are multiple records updated? (There should only be one inserted at a time I think)
ALTER TRIGGER [dbo].[UpdateNews]
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
View Complete Post