Sql server update trigger previous value

Antonio Antonio 2 2 gold badges 2 2 silver badges 11 11 bronze badges. Try to comment this condition c2. Lennart - See msdn. Antonio what do you want to happen if the name is pdated to null from not null or to a not null value from null?

And what about if the name is updated without the value changed? Add a comment. Active Oldest Votes. Improve this answer. Solomon Rutzky Solomon Rutzky Gary Gary 4 4 silver badges 12 12 bronze badges. It's simple, it's easy, it works for change sets of any size.

And, it's safe, with no race conditions or collisions with other users in the system. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. SQL Triggers - how do I get the updated value?

Ask Question. Asked 10 years, 3 months ago. Active 10 years, 3 months ago. Viewed 39k times. Improve this question. I am looking to update a record from a previous row. So if there is a value of total goods in week 1, i want that value to carry forward to the value of goods in week 2. Is there any SQL someone can share as an example of the best way to accomplish this? I can query it using lag which works great but i need the source data itself to update as the end-users are accessing the data via lightswitch, so when they save a change, i want the trigger or whatever you recommend to update the source table.

Sean Lange. Not quite sure what you are trying to do here. Are you saying when somebody updates a given row you want to update a certain column from that row using the value of another row? To offer much detailed help we will need a few things:.

Please take a few minutes and read the first article in my signature for best practices when posting questions. Need to split a string? If you run the above, you will see the lag helps shift the occupied suites to the following week. Is there a reason not to calculate these values when you need them? It is best to avoid storing calculated values in the database. It is difficult to always be absolutely certain your data is correct.

I am buiding a lightswitch application and it would be easiest i think to have it done right in the table if possible - is it even possible? It is absolutely possible. Not sure that it would be better in the database because it is a lightswitch application. How to tell what SQL Server versions you are running. Resolving could not open a connection to SQL Server errors. Ways to compare and find differences for SQL Server tables and data. Searching and finding a string value in all columns in a SQL Server table.

View all my tips. Back To Top OrderStatus then getdate when i. Hi Dr.