I asked this question How to use insert and select simultaneously?
This question clearly asks for getting the id value after a row is inserted and it was closed for duplicate of this question How to extract the last inserted row in SQL Server?
which says When an insert statement is executed one or more rows is inserted into the table, is there any way to extract the last inserted row in SQL Server?
Can anybody please tell me is this really a duplicate?