Trigger updating same table sql server
(If it cannot be that the row already has those values then leave that code out; but I've seen large UPDATES where the trigger re-updates them, changing nothing, but bloating the log and taking more CPU !! Answer will NOT be true if either is Null I still don't think you should be using NOLOCK. Answer will NOT be true if either is Null I still don't think you should be using NOLOCK.
I have a table on which simultaneous updates can happen at the same time.Please start any new threads on our new site at https://forums. We've restricted the ability to create new threads on these forums.We've got lots of great SQL Server experts to answer whatever question you can come up with. Very new to triggers I need help to create a trigger that, when a specific Column1 (Answer) in table A is updated another Column2 (Modified Answer) in Table A gets updated with a certain value.--Jeff Moden Stop thinking about what you want to do to a row...think, instead, of what you want to do to a column.
You didn't mention what goes wrong nor what the triggers do.