Posted by Erland Sommarskog on 10/01/15 11:42

devi (devivelu@gmail.com) writes:
> In oracle I have a LAG function using which I could get the previous
> value of a field.
> Do we have anything similar to that in SQL Server or access?

I have no idea what LAG does in Oracle, but the only place you can
retrieve this information easily is when you are in an UPDATE or
DELETE trigger, in which case you find the information in the
virtual table "deleted". One the transaction is committed, the only
way to retrieve the information is through a log-reader tool.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]