RE: InPlace Updates for Key columns

SSC Guru

Points: 323504

August 22, 2014 at 1:39 pm

i believe it's a design structure built into SQL, where in place updates are never truly performed.

'The design makes sense, because it allows you to reference both old and new values, via the INSERTED and DELETED virtual tables, either in a trigger or via an output clause;

it also allows a rollback to previous values, which keeps the transaction atomic /consistent. as both old and new values are in place for the transaction to process in case of an error.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!