getting a latest value that was inserted into a database.

[steve_rm]

Hello, I have a table with the primary key being a auto incremented value (IDNumber). I need to retrieve the latest value that was inserted into the database. So if the latest IDNumber is 100, I have to somehow pull this number from the database, so I can use it in my program. The main problem is, if the program is first started I need to get this value. I am using VS 2005 and SQL server 2005. Is there a simple way to do this. Thanks in advance, Steve

[sam]

fire a query which would fetch max of ur primary key column. e.g. Select Column1,Column2 FROM Table WHERE PrimaryKey = SELECT MAX(PrimaryKey) FROM Table sameer

[Navi15]

use IDENT_CURRENT( 'table_name' ) to get the last identity value generated for a specified table or view in any session and any scope.

Naveen G MCSD.Net