vb.net get last insert id from sql server 2008

[wjaram]

I'm executing a query in vb.net inserting a row into an sql server 2008 table. The table has a unique id column that auto increments on each insert. How do i get the value of the id created on the last insert. What I need is equivalent to mysql_insert_id(); in php and mysql, but I need it for vb.net and sql 2008. I'm not using a stored procedure. It an insert query directly in vb.net.

Any help would be much appreciated. I've scoured the world wide web but I haven't been able to find the answer.

 

[Sorwen]

I'm not a SQL server guru so I could be wrong on this, but as far as I remember an auto ID doesn't exist until the table has been updated and saved. The only way to get the id is to requery the table or keep track of what the ID should be.

-I hate Microsoft!
-Forever and always forward.
-My kingdom for a edit button!

 

[TipGiver]

Since it auto increments and it is identity, you can use the MAX t-sql function. SELECT MAX(id_column) FROM table. Use the .ExecuteScalar function (of the sql command). It will return the value you want.

Or you can combine the INSERT and the SELECT.

http://www.tek-tips.com/viewthread.cfm?qid=1561080&page=1