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

• Next in forum: Re: Finding the natural key
• Prev in forum: Re: Finding the natural key
• Thread view: Re: Getting previous values of a field

[Reply to this message]