Getting the last generated identity number for a certain table 2

[miraclemaker]

Hi there,
Is there a query I can run on a table that will give me the last generated identity number?

 

[Jamfool]

select IDENT_CURRENT('table_name')

regards

 

[sunila7]

Try,

SELECT MAX(IdentityFld) from TBLName

If you are trying to find the max indentity after an insert operation.

Have a look at Scope_Identity

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_globals_50u1.asp

and @@Identity

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_globals_50u1.asp

Sunil

 

[miraclemaker]

Thanks, but I get the message 'IDENT_CURRENT' is not a recognised function name.

I'm using SQL Server 7, could that be anything to do with it?

 

[miraclemaker]

I've been having some success with Scope_Identity and @@Identity, thanks.

 

[Jamfool]

yes IDENT_CURRENT is a sql2000 function. sorry.

you will have to use something like

SELECT MAX(IDENTITYCOL) FROM table_name