The automatic ID of the SQL Server insert record and the next automatic ID returned

. Scope_identity () is absolutely reliable and can be used in the stored procedure, even the trigger does not need to be created, without concurrency conflicts.

Select ident_current ('tablename') -- returns the last tag value generated in the specified table.
Select ident_incr ('tablename') -- returns the increment value of the marked field in the specified table.
Select ident_seed ('tablename') -- returns the seed value of the marked field in the specified table.

Returns the automatic number of the last inserted record.

Select ident_current ('tablename ')

Return the next automatic number:

 

Select ident_current ('tablename') + (select ident_incr ('tablename') Select @ identity -- return the last tag value generated in all tables in the current session