SQL Server 7.0 equiv of IDENTITY_CURRENT

Giganews Newsgroups
Subject: SQL Server 7.0 equiv of IDENTITY_CURRENT
Posted by:  Jack Turnbull (turnbull.ja…@ntlworld.com)
Date: Fri, 04 Aug 2006

Hi,
I am writing code for the subject version and am trying to find the
equivalent of

SELECT SaveDate FROM Performance
WHERE IDENTITYCOL = IDENT_CURRENT('Performance')

In other words I need to return a field in the last row of a table. v7.0
does not recognise IDENT_CURRENT

Any offers?

(btw, cannot upgrade - not my database)

Thanks

Replies