I've setup a method that I would like to get the last identity of a table NOT the last identity overall. If working with SQL 2000+ I can use:
This would return me the last identity inserted on the named table. Is there an equivalent using M$ Jet 4+?Code:IDENT_CURRENT('<TableName>')
At the moment I am using the following:
But this will only give me the LAST INSERTED ID overall in the database.Code:SELECT @@Identity FROM <TableName> AS UID
Regards
John
