Trigger updating same table sql server

Posted by / 12-May-2020 02:33

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.

trigger updating same table sql server-42trigger updating same table sql server-29trigger updating same table sql server-70

You didn't mention what goes wrong nor what the triggers do.

One thought on “trigger updating same table sql server”

  1. Penelope tells Jenny that she’s interested in asking Nate to the ball because he’s back from being destitute, and she wants to know the deal with him and Jenny. When Vanessa sees Nate, he invites her to the dance, but she says it’s not a great idea.