Posted by Jack Turnbull on 08/04/06 15:12

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

• Next in forum: Unable to Create a Maintenance Plan
• Prev in forum: Re: Specify SQL2005 LogFiles Path on Install
• Thread view: SQL Server 7.0 equiv of IDENTITY_CURRENT

[Reply to this message]