How to get the previous value in sql server Trigger AFTER Update Statement

Question

I would like to know how can I retrieve the older value after updated. I am using this in After update trigger and the database being used is MSSQL.

Pawel Czapski · Accepted Answer · 2018-07-23 15:02:10Z

3

You need to get data from DELETED table

SELECT ColumnName from DELETED

answered Jul 23, 2018 at 15:02

Pawel Czapski

1,8742 gold badges17 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tab Alleman · Accepted Answer · 2018-07-23 15:02:27Z

1

In the context of a trigger, you can get the pre-update value from the deleted virtual table.

answered Jul 23, 2018 at 15:02

Tab Alleman

31.8k7 gold badges41 silver badges54 bronze badges