To get an ID of last inserted record, you can use this T-SQL:

INSERT INTO Persons (FirstName) VALUES ('Joe');

SELECT ID AS LastID FROM Persons WHERE ID = @@Identity;

You can use query like this inside stored procedure or as an ad-hoc query

da:http://www.beansoftware.com/T-SQL-FA...serted-ID.aspx