Ms SQL Server gets the ID of the inserted record immediately after inserting the record

Many times we are faced with the following requirements:

After a record is inserted into a table, the ID of the record is immediately required (ID is the auto-increment identifier ). According to the conventional thinking, the SELECT statement is executed immediately after the insert statement is executed, but this is risky. If the conditions are not fully considered during the SELECT statement, the result of the SELECT statement may not be what you want (that is, it is wrong ).

Now there is an SQL statement that can directly meet the above requirements.

Insert into tbldemo values ('test') Select @ identity