How to Get Old Value

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

BeerBeerBeer SSCarpal Tunnel Points: 4021 More actions · Answer 1

do you mean before you update?

If you are inserting then there is no old value.

Select the data out before you do the update. Once you have updated it, it's gone, unless you have archive/audit tables in place.

Regards,

Steve

Life without beer is no life at all

All beer is good, some beers are just better than others

Sergiy SSC Guru Points: 110208 More actions · Answer 2

Using trigger you can catch it in table deleted.

_____________
Code for TallyGenerator