It is quite easy to get the last inserted row id in TSQL.
Just create a stored procedure as below.
Output last inserted row id in TSQL in a stored procedure
September 8, 2008 at 9:25 pm (C#, MSSQL)
Tags: id, inserted, last, MSSQL, procedure, row, stored, tsql
